OaklandJim
Well-known Member
- Joined
- Nov 29, 2018
- Messages
- 833
- Office Version
- 365
- Platform
- Windows
I found a way to clear just values (no formulas, formats, etc.) from a specified range. I found this code: .SpecialCells(xlCellTypeConstants, 23).ClearContents. I am wondering what the 23 signifies? Excel intellisense says that the type is "Value"?