Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to delete column values and formats NOT formulas
This is what I have:
Sub ClearColumns() dtTemp = Range("C1") lngLastCol = Cells(1, Columns.Count).End(xlToLeft).Column For lngcol = 4 To lngLastCol If CDate(Cells(1, lngcol)) dtTemp Then _ Columns(lngcol).ClearContents Next End Sub How do I make this so it only deletes cell values and formatting? -- Hugo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
values v formulas with conditional formats | Excel Discussion (Misc queries) | |||
Copy column, paste special formulas & number formats doesn't work | Excel Discussion (Misc queries) | |||
Pasting formats and values without formulas | Excel Worksheet Functions | |||
Using VB Copy Entire Row but formulas and formats only no values | Excel Discussion (Misc queries) | |||
delete the test values, but do not delete the formulas | Excel Discussion (Misc queries) |