MurraySMTH
Board Regular
- Joined
- Jun 30, 2020
- Messages
- 81
- Office Version
- 2016
- Platform
- Windows
Hi I am trying to fill auto-fill down the A column to the last row with the word "canceled"
I have tried a few codes. This one just puts canceled in the A2 cell.
This report will vary with rows every time i run it, so i am trying to make sure it fills out canceled for the last row each time.
I am grateful for any advice.
Thank you.
Range("A2").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "Canceled"
Range("A2").Select
Selection.AutoFill Destination:=Range("A2:A")
Range("A2:A").Select
I have tried a few codes. This one just puts canceled in the A2 cell.
This report will vary with rows every time i run it, so i am trying to make sure it fills out canceled for the last row each time.
I am grateful for any advice.
Thank you.
Range("A2").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "Canceled"
Range("A2").Select
Selection.AutoFill Destination:=Range("A2:A")
Range("A2:A").Select