I would like to grab the row number of a certain cell in a For loop, but I'm getting the 'Wrong number of arguments or invalid property assignment' error on the line: Cell.offset(1).Row = thisrow
Dim thisrow As Integer
For Each cell In rngtest
If cell.Value < linenumber And cell.Offset(1).Value > linenumber Then
If cell.Value <> "" Then
cell.Offset(1).EntireRow.Select
Selection.Insert Shift:=xlDown
cell.Offset(1).Value = linenumber
cell.Offset(1).Row = thisrow
End If
End If
Next
This seems like an easy fix, but I can't figure it out
Thanks,
Chad
Bookmarks