Get number of columns?

[Excel_ZM]

Does anyone know how to get the second line of code to work like the first one?

This one works.
LASTROW = Range("a1000000").End(xlUp).Row

This one does not work.
LASTCOLUMN = Range("XFD1").End(xlLeft).Column

 

[Joe4]

Welcome to the Board!

[COLOR=#333333]LASTCOLUMN = Range("XFD1").End([/COLOR][COLOR=#ff0000]xlToLeft)[/COLOR][COLOR=#333333].Column[/COLOR]

 

[Excel_ZM]

It worked. Thank you!
I should have checked the members of 'XIDirection'

 

[Joe4]

You are welcome!

Another trick is to just turn on the Macro Recorder, go to any cell, and then hit CTRL+LEFT ARROW and then view the code it gives you.

 

[Excel_ZM]

I should have known to do that.
I've used Macro Recorder before.