| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for copying cells above empty cells
I'm having trouble makin a macro for the following:
In column A I have varying entries of numbers or blank cells. If the cell is blank I need it to go to the nearest cell above it and copy that number. For example A1=443 A2= A3= A4=558 A5= I would need A2 and A3 to be filled with 443 and A5 to be filled with 558. please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro for copying cells above empty ones | Excel Programming | |||
| Copying values but skipping empty cells | Excel Worksheet Functions | |||
| macro to colour empty cells (cells not recognized as empty) | Excel Programming | |||
| Macro to copy value in empty cells | Excel Discussion (Misc queries) | |||
| macro to delete empty cells | Excel Programming | |||
Threaded Mode
