| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing only cells w/ numbers
I have a for loop that I want to clear only cells w/ numbers and not cells
that contain formulas or text. The following ignores cells w/ text, but clear formulas. If IsNumeric(Sheets(ToSheet).Range("List1").Rows(i)) Then Sheets(ToSheet).Range("List1").Rows(i).ClearConten ts End If How do I test for for a formula in a cell? I appreciate your help, -John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
| Clearing numbers in excel | Excel Discussion (Misc queries) | |||
| Clearing Cells | Excel Programming | |||
| Clearing Cells | New Users to Excel | |||
| Clearing cells of numbers, but not cell references. | Excel Programming | |||
Threaded Mode
