Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting a blank row when data changes
Excel Experts:
I have a spreadsheet similar to the following A B 1 4K3F 2 4K3F 3 4K3F 4 5B6L 5 5B6L 6 8E2B 7 8E2B I would like my macro to go down column A, and each time the data changes (i.e., row 4 and row 6) insert a blank row. What code would do this? Thanks Alan -- achidsey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a blank row between rows of data | Excel Worksheet Functions | |||
Inserting numerous blank lines between specific rows of data | Excel Discussion (Misc queries) | |||
Inserting data into next blank cell down in next sheet | Excel Worksheet Functions | |||
Inserting blank rows for missing data in order to transpose | Excel Worksheet Functions | |||
inserting a blank row | Excel Discussion (Misc queries) |