Thread: Offset to New Sheet
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Kanga 85 Kanga 85 is offline
external usenet poster
  
Posts: 34
Default Offset to New Sheet
Thanks Tom

"Tom Ogilvy" wrote:

If activeCell.Column = 5 then
application.Goto Worksheets("Sheet2").Range(ActiveCell.Address).Off set(0,-4)
End if

--
Regards,
Tom Ogilvy


"Kanga 85" wrote in message
...
In "Sheet1", any cell may be selected (except in Columns A-E).
I need code that will will select the cell in "Sheet2", in the same Row as
in "Sheet1', but offset 4 columns to the left. Thus if Sheet1.F5 is
selected, I need code that will select the cell Sheet2.B5.

Thanks for any help



Reply With QuoteReply With Quote