Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell
Is there away to get this to work
Activecell.Value = Offset(-1 , 9) Thanks -- Esau |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell
Assuming you're trying to assign the value one column to the left and
nine columns down from the active cell, one way: With ActiveCell .Value = .Offset(-1, 9).Value End With or, more verbosely: ActiveCell.Value = ActiveCell.Offset(-1, 9).Value In article , Esau wrote: Is there away to get this to work Activecell.Value = Offset(-1 , 9) Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell
Thanks they both work great
-- Esau "JE McGimpsey" wrote: Assuming you're trying to assign the value one column to the left and nine columns down from the active cell, one way: With ActiveCell .Value = .Offset(-1, 9).Value End With or, more verbosely: ActiveCell.Value = ActiveCell.Offset(-1, 9).Value In article , Esau wrote: Is there away to get this to work Activecell.Value = Offset(-1 , 9) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
ActiveCell | Excel Programming | |||
IF ACTIVECELL contains | Excel Programming | |||
activecell | Excel Programming | |||
Activecell value | Excel Programming |