Can anyone explain why this piece of code doesn't work?
I do get a value for a and I am trying to test to make sure the Cylsize value ends up in the right place.![]()
Sub FillDown() Dim a As Integer With Sheets("Orders_Sage") a = Me.TBRow.Value .Range(.Cells(a, 1)).Value = "Z" ' .Range("AD11").Offset(a - 10, 0).Value = Me.CBCylSize.Value End With End Sub
I just get an error, whichever way I designate the range
John
Bookmarks