| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset issue
I'm currently writing a macro where I'm trying to copy the activated cell
plus the 10 to the right but it just keeps activating the cell 10 over to the right not the entire row. This is what I'm writing Worksheets("DATA").Activate Cells.Find(What:="Name",After:=ActiveCell,LookIn:= xlFormulas, LookAt:=xlPart, SearchOrder:=xl, SearchDirection:=xlNext, MatchCase:=False, SearchFormat: =False).Activate ActiveCell.Offset(RowOffset:=0, ColumnOffset:=10).Activate Could someone tell me why it's not working? Thanks MartÃ*n Hinojosa -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell offset issue | Excel Worksheet Functions | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Offset issue? | Excel Programming | |||
| Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
| Max Offset | Excel Discussion (Misc queries) | |||
Threaded Mode
