Hi everyone, I have this code below and was hoping to get help modifying it to offset only only visible cells.
Thanks in advance for any help.
sd
Code:
If ActiveSheet.Range("X34").Value > 0 Then
HrBdg = ActiveSheet.Range("X34").Value
For i = 1 To HrBdg
Range("X33").End(xlUp).Offset(1).Value = "1"
Next i
End If
Thanks in advance for any help.
sd