I need a macro to clear contents of a specific range named "values". I got this from Walkenbach:
Cells.SpecialCells(xlCellTypeConstants), 23).Clearcontents
This works and even keeps my formatting intact but it clears ALL cells in the sheet (except formulas) - problem is that it clears my headers and labels too.. So I took all my "value" cells and named them "Values" and now I need to modify the code to just ClearContents on that range name..
Thanks in advance!
Cells.SpecialCells(xlCellTypeConstants), 23).Clearcontents
This works and even keeps my formatting intact but it clears ALL cells in the sheet (except formulas) - problem is that it clears my headers and labels too.. So I took all my "value" cells and named them "Values" and now I need to modify the code to just ClearContents on that range name..
Thanks in advance!