I'm working on a VBA macro for Excel and I am having a problem with Selection.Autofill
What is happening (I think...) is that the formulas are only autofilled until there is a break in the data from the preceding column. My formulas, beginning in column U, are not dragged down past the place where column T has two blank cells.
I've tried working around this by doing a second autofill, but my results were unreliable since the data changes from each instance. Is there a way to continue the autofill past the break in column T, while still stopping at the end of data in column A?
Here's the portion I'm referring to. If you would like to see this in context of the larger VB I can post that as well.
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
Selection.AutoFill Destination:=Range("U2:BF" & LR), Type:=xlFillDefault