Correct VBA syntax
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? |
Correct VBA syntax
One way:
ActiveSheet.Cells(rownum, colnum).Activate In article , Ken G. wrote: 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? |
Correct VBA syntax
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 "Ken G." wrote: 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? |
Correct VBA syntax
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? "JE McGimpsey" wrote: One way: ActiveSheet.Cells(rownum, colnum).Activate In article , Ken G. wrote: 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? |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com