View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Reading location of active cell

ActiveCell.Offset(-1,0).select

If the cursor is in row 1 when you try to do this command you will recieve
an error, To avoid this you can do so:

If ActiveCell.Row1 then
ActiveCell.Offset(-1,0).select
End If

Hopes this helps.

---
Per


"Dean" skrev i meddelelsen
...
Hello,
For my project I am making on excel, I need to move the selected cell
up so for example if I click on A2 then A1 would be selected
Is this possible,
Thanks