activeCell.offset in another worksheet
 

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.

activeCell.offset in another worksheet
 

Hi

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

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"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.

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.