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.