Results 1 to 3 of 3

Thread: Excel Dynamic range ?

  1. Jan 23rd, 2002, 02:59 PM #1
    SeaHag
    SeaHag is offline

    Thread Starter
    Fanatic Member SeaHag's Avatar
    Join Date
    Jul 2001
    Location
    Lake Huron
    Posts
    901

    Excel Dynamic range ?

    I have seen this done somewhere..

    Can i have a a range object that will grow with my expanding
    list..


    like myrange = range c3 to range EOF

    ??

    That is all
    Seahag
    Reply With Quote Reply With Quote
  2. Jan 23rd, 2002, 03:04 PM #2
    MetallicaD
    MetallicaD is offline
    Hyperactive Member MetallicaD's Avatar
    Join Date
    Feb 2001
    Location
    Tallahassee, FL
    Posts
    488
    Select the top of your range

    using: Range("A1").Select (or something)

    Then this is like pressing end and the down arrow:

    Selection.End(xlDown).Select

    You may need to add to the front of these commands a qualifier.. this code was taken right out of excel vba..

    try.. objExcel.ActiveDocument.Selection.End(xlDown).Select


    -mcd
    [vbcode]
    '*****************************
    MsgBox "MCD :: [email protected]", vbInformation + vbOKOnly, "User"
    '*****************************
    [/vbcode]
    Reply With Quote Reply With Quote
  3. Jan 23rd, 2002, 03:26 PM #3
    SeaHag
    SeaHag is offline

    Thread Starter
    Fanatic Member SeaHag's Avatar
    Join Date
    Jul 2001
    Location
    Lake Huron
    Posts
    901
    Cant get that to work..
    Selection is a word.. thinggy..


    I seen a real nifty way of doing it.. cant believe
    I didn`t save it..
    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width