View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default activeCell.offset in another worksheet

Francois,

I'm not sure that there is an activecell in a workbook that is not active.
You can reference a single cell, or an offset, as in the example below.

Sub UpdateOtherBook()
Workbooks("Book1").Sheets(1).Cells(1, 1).Offset(1,0).Value = "hello"
End Sub

Robin Hammond
www.enhanceddatasystems.com

"François" wrote in message
...
Hello,
To save some time on process I'm searching a way to do something like
Sheets(cFromWb).ActiveCell.Offset(1, 0).Select where cFromWB is not the
current active worksheet. But this is a wrong instruction.
Does somebody has an idea how to solve this ?

Many Thanks.