View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default 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.