activeCell.offset in another worksheet

[Guest]

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.

 

[Arvi Laanemets]

Hi

Try this:
Sheets(cFromWb).Range(ActiveCell.Address).Offset(1, 0).Select

 

[Robin Hammond]

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