| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Looks for Cell Contents & Performs Action
I am trying to create a Macro in Excel that looks at the text in each cell in
column A: -if the cell begins with " D" (three spaces and a D) then I need to cut the cell and paste it up one row and right one column, then delete the row from which it came -if the cell does not begin with " D", then move down one cell The loop should end when a cell contains "***" This seems pretty easy, but I'm new to VBA... Thanks, Adam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to perform action based on value in cell | Excel Programming | |||
| Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
| How to create a macro which performs a copy-and-paste task every 5mins after data is refreshed from web page? | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| How to change macro so it performs actions on ACTIVE sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
