Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Vancouver, Canada
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Selecting a particular range including blanks (Excel 2000 SR1)

    I lied...when I recorded the macro...it had 11 lines of Range(Selection, Selection.End(xlDown)).Select but when I actually add that to my existing macro...it only takes me down to the first blank row...there are 5 sections of blank rows that I need to include in the range...can anyone help me?

    Thanks,

    Christa

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Selecting a particular range including blanks (Excel 2000 SR1)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Christa

    By any chance can you remove these blanks? Why do you have these blanks? Could you place these 5 items into 5 worksheets?

    See my other replies to your other message.

    Wassim <img src=/S/compute.gif border=0 alt=compute width=40 height=20>
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Selecting a particular range including blanks (Excel 2000 SR1)

    This is covered in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=116543&page=0 &view=expanded&sb=5&o=0&fpart=>this post</A>- please post replies there.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •