Add text after the last column.

[johnnyvv]

I want to add text after the last column in a macro
in the spreadsheet but dont know what the last will be.

So if the data ends in column 'T' i want to add the word ''last'' into column 'U'. But i wont know what the last column will be.

 

[zzjasonzz]

if you know the row and
a) there are no blanks in the data you can use

range("A1").end(xltoright).column

b) there are blanks in the data you can use

range("IV1").end(xltoleft).column

in your example both of these will return 20 (the number equivalent of T)

so you can do something like

cells(1,(range("IV1").end(xltoleft).column + 1)) = "last"

 

[johnnyvv]

hmm tried but it didnt work.

Just want to add the text ''Last''
into row 13 after the last column.

 

[zzjasonzz]

cells(13,(range("IV13").end(xltoleft).column + 1)) = "last"

 

[johnnyvv]

That worked Perfectly.

Appreciate the help. Thankyou very much!