H
Hinojosa via OfficeKB.com
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
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