Re: Macro to number blank cells

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

From: Anne Troy (dreamboat_at_piersontech.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 11:30:16 -0400

Can it be this simple? I'm not positive that I understand what you're
asking. But try this.
You have blank rows below each record.
Select the columns B through G, beginning with the first BLANK row and down
all rows.
Hit Edit-Go to-Special and choose Blanks, Ok.
Now, assuming your first blank row was row 3, we'll type into B3:

=b2

Then hit Ctrl+Enter.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Com.Piersontech@Dreamboat
(Reverse it!)
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

"Fernando Gomez" <fgomez@golden.net> wrote in message
news:%23oSYGcsLEHA.3472@TK2MSFTNGP09.phx.gbl...
> In one row I have:
> A B C D
E
> F G
> Cust# Address 1 Address 2 Address3 Address 4 Address5
> Address6
>
> I have a macro that inserts 6 rows below each name, how could I copy
> information in columns B-G to the 6 cells below cust #, Thanks in advance
> for your help
>
> Fernando
>
>
>
>

Relevant Pages

  • Re: Macro to number blank cells
    ... > Anne Troy (better known as Dreamboat) ... > (Reverse it!) ...
    (microsoft.public.excel)
  • Re: Reversing a list - Back again!
    ... OK - Plan B. Again assuming each line is a paragraph, the following macro ... will reverse the list on a place by place basis. ... London Town ...
    (microsoft.public.word.newusers)
  • Re: Aperture - love it.
    ... >>> Tell me what aperture setting is optimal for a macro to maximize focus ... > maximum depth of field you stop the lens all the way down. ... This will approx triple your magnification. ... Go here and search for 'reverse' for a better explanation: ...
    (comp.sys.mac.advocacy)
  • Re: autonumbering
    ... Hmm, if you want to number text in a single sequence, you can use the macro ... Note that the macro keeps track of the sequence by storing the current value ... reverse the order starting from 1 at the bottom of the sheet and adding ... create a reverse numbering sequence. ...
    (microsoft.public.word.docmanagement)
  • Re: Button Problem
    ... Are you saying you have two macros -one to sub total the other to reverse it, if yes post your code as I suspect that may be the problem. ... When I push the button it kicks off the macro and subtotals the sheet. ...
    (microsoft.public.excel.programming)