opening a worksheet to have next blank cell in column a active

[nicody]

Good afternoon,

I have code written to open worksheets with command tabs on another sheet. My problem is that I need the active cell on that sheet to be the next available blank cell in column A. There will be not blanks cells above so that will not be an issue for this sheet.

This is the code I have but it is giving me an error at the last line.

Please Login or Register  to view this content.

Any suggestions?
Thanks,
Deb

[Mumps1]

Your code works for me.