Last column code

[llan_man]

Hi

I have detailed some code below which I thought will give me the next free column in the sheet. However it keeps giving me an object defined error.

NextColumnAss = (Range("IV2").End(xlLeft).Column) + 1

Any ideas gratefully received.

Harv

 

[Yogi Anand]

Hi Harv:

Try ...

NextColumnAss = (Range("IV2").End(xlToLeft).Column) + 1