| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert blank row above populated cell
Hi there, I have a column mostly consisting of blank cells. What I
need is some vba that finds any populated cells and then inserts a new row above it. Is the best way to do this by using ISTEXT, or NOT (ISBLANK). I'm sure the answer is very simple, but not for me! Any advice would be really appreciated. Thank u, BJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells but leaving blank if not populated | Excel Worksheet Functions | |||
| How do I insert a work sheet populated with data into another? | Excel Worksheet Functions | |||
| First populated cell in row array/ Last populated cell in row arra | Excel Worksheet Functions | |||
| formula for a cell which is blank returns populated cell | Excel Discussion (Misc queries) | |||
| Auto insert Date & Time when another cell is populated | Excel Discussion (Misc queries) | |||
Threaded Mode
