Select data within a list

[elgringo56]

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

 

[Legacy 98055]

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

 

[Ivan F Moala]

Is your data text,numbers, formulas ??
combination of all ??

 

[elgringo56]

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.