Select data within a list

elgringo56 · Apr 16th, 2002, 09:08 PM

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

Tom Schreiner · Apr 16th, 2002, 09:34 PM

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 · Apr 16th, 2002, 09:40 PM

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

elgringo56 · Apr 17th, 2002, 06:23 AM

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.

Apr 16th, 2002, 09:40 PM	#3
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Is your data text,numbers, formulas ?? combination of all ?? __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 09:08 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	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

Apr 16th, 2002, 09:34 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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

Apr 17th, 2002, 06:23 AM	#4
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	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.