ActiveCell.Value = Sheets("schd").Offset(-2, 6).Value

The Cells property cannot take negative values as it refers to the rows and
columns relative to the sheet, and negative is invalid. Offset refers to the
activecell, so there can be a negative value here.

--
HTH

Bob Phillips

"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??