willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 915
- Office Version
- 365
- Platform
- Windows
Hello,
I have a vba code that will fill a series from A11 down however if there is only 1 item (A11) I need something in my code that will recognize this and not give me an error but continue with my macro. What could I add to this line to have that happen?
ActiveCell.FormulaR1C1 = "1"
Range("A11").AutoFill Destination:=Range("A11:A" & Cells(Rows.Count, "B").End(xlUp).Row), Type:=xlFillSeries
Thank you
Carla
I have a vba code that will fill a series from A11 down however if there is only 1 item (A11) I need something in my code that will recognize this and not give me an error but continue with my macro. What could I add to this line to have that happen?
ActiveCell.FormulaR1C1 = "1"
Range("A11").AutoFill Destination:=Range("A11:A" & Cells(Rows.Count, "B").End(xlUp).Row), Type:=xlFillSeries
Thank you
Carla