I have used the following to get the last used column in a row, but is there any quick way to transfer this number into the column letters, other than a huge select case or similar. I'm sure there must be, but can't find anything so far![]()
E.G. LastCol = 34
LastCol = AH
For me the LastCol would be "LastCol - 1" as the last column in the row is optional.
VB Code:
LastCol = ActiveSheet.Range("IV1").End(xlToLeft).Column




Reply With Quote