Userform to add data to active cell offset

[Nitefox]

I am trying to get my userform to add data to an active cell offset. Im getting run time error 1004 with the following code:

With Sheets("ReturnData")
CR = ActiveCell.Offset(-1, -1)

.Cells(CR, 1).Value = ItemDescription.Value

End With

What am I doing wrong?

[AB33]

If you ractive sheet is A1, you can not go to the left of it, nor you can go above it, so it all depends where is the active cell is in the grid.

[berlan]

If you have defined CR as a range, then perhaps this:

Please Login or Register  to view this content.