Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveCell.Offset Question | New Users to Excel | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
Activecell Offset | Excel Programming | |||
ActiveCell.Offset w/ VBA | Excel Programming | |||
activecell offset | Excel Programming |