Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running auto correct on startup? | Excel Discussion (Misc queries) | |||
BringToFront syntax question | Charts and Charting in Excel | |||
Insert more than 1 Row Syntax | Excel Worksheet Functions | |||
what is the correct syntax for an allowable circular reference? | Excel Discussion (Misc queries) | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions |