| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activecell offset
how do i shift the active cell, two cells to the left.
i know that activecell.offset(0,1) will shift it one cell to the right. how to do for right?? --- Message posted from http://www.ExcelForum.com/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
activecell offset
Beware when you are close to column 1 (Column A)
Activecell.offset(0,-2) "rvik" wrote in message ... how do i shift the active cell, two cells to the left. i know that activecell.offset(0,1) will shift it one cell to the right. how to do for right?? --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveCell.Offset Question | New Users to Excel | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Sum Activecell Offset Problem | Excel Worksheet Functions | |||
| how to set activecell? | Excel Programming | |||
Linear Mode
