View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KnightRiderAW KnightRiderAW is offline
external usenet poster
 
Posts: 20
Default Excel macro to insert blank rows at a ever-changing interval

I have a list of names, addresses, and phone numbers all located in column A.
I need to insert a blank row after each phone number (which is formatted as
bold and in the style of (###) ###-####. Can someone help me on this. I
have a macro to make user-friendly after this point, but I can't seem to get
the row to insert. Please note that the grouping may vary from Company to
Company (2, 3, 4, or 5 lines of info), so I can't use a constant value.

Using Excel 2003 on Windows Server 2003. Thanks!

-Aaron