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
|