ActiveCell
 

Is there away to get this to work

Activecell.Value = Offset(-1 , 9)

Thanks
--
Esau

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

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