Help with inserting a blank line on condition

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I've been programming in other languages but am very new to VB and still getting used to its syntax style - so I'm stuck with the simplest of problems.

What I have is an excel spreadsheet (obviously). In column A there are text strings (names) that have been sorted into groups. So basically groups of names down the column. All I want to do is add a complete blank row after each name group - the number of names in each group is not consistent.

eg

Peter
Peter
Peter

Paul
Paul

Mary
Mary
Mary
Mary

Can someone provide some help here?

Thanks

.

Relevant Pages

  • Re: OT: How things have changed
    ... Germany is back as one country etc..... ... languages including *Russian*. ... best pizza crust recipe is the simplest one I've ever found. ...
    (sci.electronics.design)
  • Re: saving and msgboxes
    ... I stuck your code in my cmdClose button, ... To interrupt this process, probably the simplest ... approach is to use the Before Update event of the form. ...
    (microsoft.public.access.formscoding)
  • Re: printf("%d",*(&ptr2 + 2))
    ... If you get stuck with that, ... The simplest way to do this is as follows: ... i am not playing games by printing numbers. ... Fred Kleinschmidt ...
    (comp.lang.c)
  • German Capital
    ... Does Luther enter in that Picture? ... Why has it stuck to it? ... Did other Languages follow that Tradition some Time? ...
    (sci.lang)
  • Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
    ... current programming language is: object. ... Objects are essentially maps with a little syntactic surgar. ... simplest OO languages, objects and maps are nearly indistinguishable.Is that so ?? ... Please feel free to provide us with the names of the "simplest OO ...
    (comp.object)