Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need simple code to skip blank rows
I have a worksheet that has blocks of part/order numbers that have to
be sorted by date and segmented with a blank row between each block. I know it's not the best practice to have blank rows in between data but thats what management wants. So I need help with code to search through this worksheet, ignore 1 blank row between each segment, and find the end of the data on the sheet. At that point I will insert another blank row then insert data from a Sales Order which I have already coded. I appreciate any help, Thank you, Chad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to number but skip blank rows | Excel Discussion (Misc queries) | |||
copy from one sheet to another and skip the blank rows | Excel Discussion (Misc queries) | |||
VBA code to hide blank rows | Excel Worksheet Functions | |||
simple code hide/show rows with cell = empty, set value or any val | Excel Programming | |||
skip blank rows when pasting formulas | Excel Worksheet Functions |