VBA code to select last cell in row with data

[ronnie76]

I have a row of formulas that reference other sheets in my workbook (i.e. Cell A4=Sheet2!A1, Cell B4=Sheet2!B1, etc). I need to have VBA find the last cell in that row with data. I tried "End(xlToRight).Column" but it goes all the way to the end because all of the cells have formulas. I need to find the last cell that is empty of data or maybe >0 would work. Sorry if this is confusing. Thanks for any and all help.

 

[erik.van.geit]

when looking to the last example you posted, that's the same example as mine, only not the same row (you said row 4 in your original post)

To get the required result you only need to replace the 4 in my first code by 2.

You wouldn't knock at each door in a street to ask if a certain mister Jones is living there, if you can FIND it in an addressbook. So avoid code which is looping, even when it is reading more easily at first sight: the other code will also read easily once you understand how FIND works

 

[ironwood90242]

I'm glad some found solutions that worked in this thread - none worked for me, but I found this on MrExcel, and it worked perfect !

Range("A:A".Find("").Select

I needed to go to the last row with data (NOT 'ghost data' - that was an issue with "tables"), and go there - very grateful to whoever posted that....

 

[billritz]

In the second, you asked it to go right from the last column; you probably meant xlToLeft