oblix
Board Regular
- Joined
- Mar 29, 2017
- Messages
- 183
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
- Web
I Have Tried this, but dont get it wright.
Sub Clear_Perm1()
Worksheets("PERMENANT LIVING IN REGISTER").Range("C6:AV447").SpecialCells(xlCellTypeConstants, 23).ClearContents
Range("C1").Select
End Sub
What have I done Wrong?
VBA Code:
Worksheets("PERMENANT LIVING IN REGISTER").Range("C6:AV447").SpecialCells(xlCellTypeConstants, 23).ClearContents
Range("C1").Select
End Sub
What have I done Wrong?