Selecting the first free cell 1

[LGMan]

Hi,
Can anyone point me in the direction of the correct code for finding the first free cell within Col A on a worksheet.

Thanks in advance

 

[SkipVought]

Hi,

I would advise against SELECTING the cell, but rather REFERENCING the cell...

dim rNext as range
set rNext = cells(cells.count, "A").end(xlup).offset(1)

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[LGMan]

thanks skip, however I get a runtime error 1004 on the Set rNext = Cells....

I expect I've missed something

 

[SkipVought]

Sorry

dim rNext as range
set rNext = cells(cells.ROWS.count, "A").end(xlup).offset(1)

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[LGMan]

Thanks Skip, hope you see the star. it's really a cumulative one for all the help that you've given me recently.

 

[SkipVought]

Glad to help.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}