Insert blank cell before bold names

[Ohucan2]

I have 5000 names and addresses that are in excel as one long column, each cell has data., there is no space between address blocks. I need to divide the addresses, and they are not all the same number of cells. The only distinquishing field is the name, which bold. Is there a what to format this, inserting a blank cell before each cell that is formatted with bold?

[Palmetto]

Copy this code to a standard module and give it a try. Assumption: "bold" cells are in column-A. Change reference in code as required.

Please Login or Register  to view this content.

[Ohucan2]

Thank you, but I don't have a clue where to put that code? Module, is that a formula? DO I select the whole column first?

Sorry, but I am a newbie.

[Palmetto]

Open the target workbook, then

Adding the Macro

1. Highlight and copy the macro above pressing the keys CTRL+C
2. Press the keys ALT+F11 to open the Visual Basic Editor
3. Press the keys ALT+I to activate the Insert menu
4. Press M to insert a Standard Module
5. Paste the code by pressing the keys CTRL+V
6. Make any custom changes to the macro if needed at this time.
7. Save the Macro by pressing the keys CTRL+S
8. Press the keys ALT+Q to exit the Editor, and return to Excel.


To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

[whyeemee]

Open the target workbook, then

Adding the Macro

1. Highlight and copy the macro above pressing the keys CTRL+C
2. Press the keys ALT+F11 to open the Visual Basic Editor
3. Press the keys ALT+I to activate the Insert menu
4. Press M to insert a Standard Module
5. Paste the code by pressing the keys CTRL+V
6. Make any custom changes to the macro if needed at this time.
7. Save the Macro by pressing the keys CTRL+S
8. Press the keys ALT+Q to exit the Editor, and return to Excel.


To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

This works great but how do I insert the row above the BOLD rather than below?

Thanks!

[arlu1201]

Change this line from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.