Column count in range

[Edman]

After some many attempts I have not been able to make this work.

I always use:

FinalRow = Cells(Rows.Count, 2).End(xlUp).Row

to find the number of of rows in my data range.

I have attempted the same thing for columns:

FinalCell = Cells(30, Cells.Count).End(xlToRight).Cells

I am getting an error. Can anyone tell me what I am doing wrong?

 

[Mike Blackman]

Hi,

Are you trying to find the final Column? I'd suggest;

lCol = Cells(30, Columns.count).End(xlToLeft).Column

 

[Edman]

Yes sir that does the trick!

Thanks for the quick reply.