Find last used column
I am using the following to try to identify the last used column and then
select the top cell of the first empty column after the last used:
myRange = ActiveSheet.UsedRange
NewColumn = (myRange.Columns(myRange.Columns.Count).Column) + 1
ActiveSheet.Cells(1, NewColumn).Select
Can anyone tell me what I am doing wrong? This is not working. The portion
in () in the second line I copied from the help file, but do not understand.
--
Regards,
Bryan Brassell
Padgett Business Services
281-897-9141
|