Excel 4.0 : Selecting Extract Data

Thread View: comp.apps.spreadsheets

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Stuart Baker Tue, 22 Dec 1992 14:55

#229

Author: Stuart Baker
Date: Tue, 22 Dec 1992 14:55

29 lines
1645 bytes

Thank to those who responded to my inquiry about setting a print area for an
unlimited extract range.  I actually ended up using a compilation of efforts
to do the deed. I have put the macro below. The key command is the
=Select.Special(5) command which is the equivalent of Control & Shift & *,
which selects the current region. The line after that returns the selection
range, minus the top row which is the print title row of the extract range.


*****EXCEL MACRO TO AUTOMATICALLY SELECT A REGION & DEFINE PRINT AREA & PRINT

PrintExtract
		=ECHO(FALSE)
Print_Ext	=ALERT("Do you want to print the extracted data?",1)
		=IF(Print_Ext=FALSE,GOTO(EndExtPrint))
		=MESSAGE(TRUE,Printing Extracted Data, please wait")
		=FORMULA.GOTO("Extract_Home")
		=SELECT.SPECIAL(5)
		=SELECT(OFFSET(SELECTION(),1,0)
		=SET.PRINT.AREA()
		=FORMULA.GOTO("Extract_Home")
		=PRINT()
EndExtPrint	=MESSAGE(FALSE)
		=RETURN()

---------------------
Stu D. Baker				Mitchell Media Center
Multimedia Services Specialist		Northwestern University Library
E-MAIL: stubaker@nwu.edu		1935 Sheridan Road.
VOICE: 708.467.1984			Evanston, Illinois   60208-2323

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads