Hi Liz

This will give you the last filled column in Row 1.
lngLastCol = ActiveSheet.Cells(1, Columns.Count).End(xlToLeft).Column

When you work with column numbers and row numbers try

Range(Cells(r1,c1), Cells(r2,c2))
where r1,c1,r2,c2 are numbers


If this post helps click Yes
---------------
Jacob Skaria


"Liz" wrote:

I am stumped...

How do I add a column after the last column used? The last column used is
an unkown and varies per worksheet.

Working with rows and last row seams easier....I am getting confused because
counts are numbers, and column referencing for ranges is in letter format....

Thanks,
Liz