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