Hi community,
again I need your help. I have columns with formulas and I would like to have these filled in automatically down to the last line.
My variable is set up like this:
Dim l As Long
l = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
and in column P happens this:
Range("P1") = "BU Group 2" '>> Giving column name
Range("P2").Formula = "=VLOOKUP($N2,Centres!$B:$D,3,0)" '>> check for values in different tab
Range("P2:P" & l).Filldown '>> expected fill down of formular above
The filldown works prober until line 104.
But the report has a dynamic range constantly over 8000 lines
I checked the sheet the vlookup refers to, but can't find an error.
Is there something fron with my code or do I miss something else?
Please let me know if you need more information.
Cheers
Chris
again I need your help. I have columns with formulas and I would like to have these filled in automatically down to the last line.
My variable is set up like this:
Dim l As Long
l = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
and in column P happens this:
Range("P1") = "BU Group 2" '>> Giving column name
Range("P2").Formula = "=VLOOKUP($N2,Centres!$B:$D,3,0)" '>> check for values in different tab
Range("P2:P" & l).Filldown '>> expected fill down of formular above
The filldown works prober until line 104.
But the report has a dynamic range constantly over 8000 lines
I checked the sheet the vlookup refers to, but can't find an error.
Is there something fron with my code or do I miss something else?
Please let me know if you need more information.
Cheers
Chris