Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Help!
How to make a macro who will find every cell (in a specific column - for example, column B) and erase content, if that content is a number with one, two, three, four or five digits. For example: Cell 1 3858884116322 Cell 2 3856003215644 Cell 3 41862 Cell 4 4569888 Cell 5 499 Cell 6 0 Macro must eliminate (just erase content - not cell) cell 3, 5 and 6 (column B). Thanx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
C3,
If you are dealing with numbers only select your range and run this macro Sub Macro1() For Each cell In Selection If cell.Value < 100000 Then cell.ClearContents End If Next End Sub HTH Cecil "C3" wrote in message ... Help! How to make a macro who will find every cell (in a specific column - for example, column B) and erase content, if that content is a number with one, two, three, four or five digits. For example: Cell 1 3858884116322 Cell 2 3856003215644 Cell 3 41862 Cell 4 4569888 Cell 5 499 Cell 6 0 Macro must eliminate (just erase content - not cell) cell 3, 5 and 6 (column B). Thanx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |