goto a particular cell

  • Thread starter Thread starter Patrick Molloy
  • Start date Start date
I have just read that some times the Range class doesn't work when the cell
we are trying to activate is empty.
In my case this is true - how can I get round this?
 
Try this code (assumes column A can be used to find the last used row)

cells(rows.count,1).End(xlup).offset(1,5).Select

Make sure you don't have the sheet protected.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Issues with time clock 5
End Sub if InputBox cancelled (False) 5
Make a particular cell the active one 3
for loop with If then question 10
Find in a column 9
....SPOT THE USERFORM!!!!..... 4
WHY OH WHY DOESN'T THIS WORK!!!!! 3
for loop with if statement 1

Back
Top