Home |
Search |
Today's Posts |
#1
|
|||
|
|||
moving around cell
hi,
using code how do you move up down, left, right? activecell.moveleft 1 or something like that Thnks |
#2
|
|||
|
|||
Look at offset
-- Regards, Peo Sjoblom "Bre-x" wrote in message ... hi, using code how do you move up down, left, right? activecell.moveleft 1 or something like that Thnks |
#3
|
|||
|
|||
Bre-x
ActiveCell.Offset(0,-1).Select will move left one cell ActiveCell.Offset(2, 1).Select move down two, right one ActiveCell.Cells(3, 2).Select move down two, right one ActiveCell.Range("B3").Select move down two, right one -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Bre-x" wrote in message ... hi, using code how do you move up down, left, right? activecell.moveleft 1 or something like that Thnks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow keys move screen instead of moving from cell to cell. | Setting up and Configuration of Excel | |||
Moving cursor to next open cell | New Users to Excel | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Moving text in a cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |