MrManBoy
New Member
- Joined
- May 28, 2014
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hi Team,
Trying to achieve:
I want to be able to run the below macro on the next available blank cell in column D.
Code:
Many Thanks for any assistance
Trying to achieve:
I want to be able to run the below macro on the next available blank cell in column D.
Code:
Code:
Range("D6").Select
ActiveCell.FormulaR1C1 = "Not Started"
Range("D6").Select
Application.Goto Reference:="R6C4:R6C17"
Selection.FillRight
Range("D6").Select
Selection.End(xlToLeft).Select
Many Thanks for any assistance
