Insert row after every blank

  • Thread starter Thread starter vikram
  • Start date Start date
V

vikram

Hi All,

Can we have a macro which inserts a row after every blank in
column....example

135650 Ryan & Associates
105135 University of New
Orleans Louisiana
97400 Sprint Corp

99911 E2O Communications Inc
158118 Bakhtar Associates
184881 QWEST COMMUNICATIONS
184881 QWEST COMMUNICATIONS



the first column is column A, upon finding a gap it inserts a row afte
that gap and moreover if there is no gap like the last 4 in the exampl
, it inserts a row in between all of them

thank u so much guys..
 
For the first part - why a macro? Select range in question, do Edit / Go To /
Special / Blanks, then do Edit / Insert / Rows.

For the second, how on earth is any piece of code going to distinguish between
the last 4 rows in your example and say the first 5 rows. Every piece of code
needs an element of logic to follow in order to make the calls that might seem
natural to you, but there is nothing I can see that says why you wouldn't put a
blank in between all the first 5 as well, or vice versa simply treat the last 4
as you would the first 5.
 
Back
Top