range offset
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??
|