Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to Active Row Column B
I want a code that will move the cursor to Column B, but not move it from the
ActiveRow. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to Active Row Column B
Hi
one method is to use the offset function... e.g. activecell.offset(0,1).select moves the cursor one column to the right activecell.offset(0,-1).select moves the cursor one column to the left however, generally you don't need to "select" a cell to work with it e.g. activecell.offset(0,5).value = "cat" places the word "cat" in the 5th column to the right of the current cell. Cheers JulieD "scrabtree23" wrote in message ... I want a code that will move the cursor to Column B, but not move it from the ActiveRow. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to Active Row Column B
Hi
cells(activecell.row,2).select "scrabtree23" wrote: I want a code that will move the cursor to Column B, but not move it from the ActiveRow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button macro to move/delete active row | Excel Discussion (Misc queries) | |||
move from active cell offset in macro | Excel Discussion (Misc queries) | |||
Move active cell to same location on each worksheet | Excel Discussion (Misc queries) | |||
Move Active Workbook to another Folder | Excel Discussion (Misc queries) | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) |