Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Select data within a list

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Puerto Vallarta, Mexico
    Posts
    869
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a list that is 6 columns wide and up to 1000 rows long. this list has an unknown amount of data in it. I want to select only those cells that contain data under macro control. I will be darned if I can figgure out how to do it? Help, please

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    I am not sure if there is a limit to how many seperate selections you can have at one time?
    What are doing with the data after you select it?
    Thanks,
    Tom

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is your data text,numbers, formulas ??
    combination of all ??
    Kind Regards,
    Ivan F Moala From the City of Sails

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Puerto Vallarta, Mexico
    Posts
    869
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The data is alpha or numeric, what I am going to do with it is print it using print selection. My problem is selecting an unknown quantity of data to print so that the printer doesn't spit out a ton of blank sheets after the needed data is printed.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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