View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default go last row when file is opened

Hi,

Without programming you might try pressing Ctrl+End and then Home.

This will work in certain situations.

You have provided very few details - does the whole row need to be blank or
only certain cells, which column in the empty row do you want to go to, A or
IV? How is your data set up on the sheet - is it solid or is every other row
blank, or something else? What if you are on the wrong sheet? Do you want
to count cells with formats or just cells with data when you are considering
a blank row?

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Wanna Learn" wrote:

Hello Whenever the workbook is opened I the cursor to go to the next
empty row. How do I do that? thanks