| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
test a cells type
I want to step through a range clearing the contents of
cells with number values, but not formulas. The following code doesn't work: If ActiveCell.Offset(currow - 1, 0).Type < xlCellTypeFormulas Then ActiveCell.Offset(currow - 1, 0).ClearContents End If Does the constant "xlcelltypeformulas" only work with the "specialCells" method? Is there another solution? DM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add time from multiple cells & date Cells & machine type c | Excel Worksheet Functions | |||
| Logical Test with multiple cells | Excel Worksheet Functions | |||
| Test for coloured cells? | Excel Discussion (Misc queries) | |||
| Test for data in a range of cells | Excel Worksheet Functions | |||
| an error.type test | Excel Worksheet Functions | |||
Threaded Mode
