Can Column Offset in VB code be told to go to column A?

**mrgillus** · 08-19-2009, 12:45 PM

Please Login or Register  to view this content.

This will not consistantly work for some reason- Sometimes it goes all the way back to column A and sometimes it comes up short and stops at Column B which causes it to crash. Can Offset be told to go back to the beginning of the columns (column A)? or is there another line of code for VB that will do that?

Thanks!

**Leith Ross** · 08-19-2009, 12:52 PM

Hello mrgillus,

If you want to go back to "A1", select the cell. There is no need to use Offset if this cell will always be the final selection.

Please Login or Register  to view this content.

**Richard Schollar** · 08-19-2009, 12:54 PM

You could avoid using Offset altogether:

Please Login or Register  to view this content.

In place of the row containing your red highlighted text.

**mrgillus** · 08-19-2009, 03:05 PM

Hey Thanks guys for the fast response.. Sorry for the delay in getting back.. I have been testing Rich's method.. That seems to be working so far..

Leith, the reason I didn't want to go to A1 is because I need to go to the end of the last page so it can post a new page.. otherwise it will be pasting over the existing page.

Thanks for all your help guys!