K
Ken G.
What is the correct vba syntax to use to make a particular cell the active
cell when the row number and column number are known?
cell when the row number and column number are known?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
ActiveSheet.Cells(rownum, colnum).Activate
ActiveSheet.Cells(rownum, colnum).Activate
E
exceluserforeman
If the current cell is known (even if you do not know where that is) and you
want to know the value of a cell 2 columns over and 5 rows down then
activecell.offset(0,0).select
msgbox activecell.offset(5,2) .value,vbinformation, "Offset Manager"
- - Mark
want to know the value of a cell 2 columns over and 5 rows down then
activecell.offset(0,0).select
msgbox activecell.offset(5,2) .value,vbinformation, "Offset Manager"
- - Mark
K
Ken G.
Thanks for this. I'm trying to get the active cell to remain the same when
enter is pressed, but in a protected sheet it jumps to the next unprotected
cell. I thought I may have been able to do it with your response below but I
can't get it to work. Can you help with a macro to do this?
enter is pressed, but in a protected sheet it jumps to the next unprotected
cell. I thought I may have been able to do it with your response below but I
can't get it to work. Can you help with a macro to do this?