Are you looking for

ActiveCell.Value = ActiveCell.Offset(-2,6).Value

--
steveB

Remove "AYN" from email to respond
"bbxrider" wrote in message
...
trying to set the active cell to the value of another cell via an offset
reference
have tried all these and mostly get an 1004 illegal object error
ActiveCell.Value = Sheets("schd").Cells(-2, 6).Value
ActiveCell.Value = workSheets("schd").Cells(-2, 6).Value
ActiveCell.Value = Range(Cells(-2,6), Cells(-2,6)).value

the formula works if i hard code the value like
ActiveCell.Value = Range("J2:J2).value

but need to have the offset methodology

there must be some way to do this with an 'offset' reference?? yes??