Excel: Extract Range Macro Question

Article View: comp.apps.spreadsheets

Article #260

Back to comp.apps.spreadsheets Previous Next

#260

From: Stuart Baker
Date: Sat, 19 Dec 1992 15:34

19 lines
1377 bytes

I have an Excel 4.0 problem I am hoping someone has a solution to:

I have a database setup where I am extracting data to an extract range
that is unlimited in nature.  Sometimes I extract a few records and
sometimes several hundred.  I want to write a macro that will select
the extracted data (no matter how many records are extracted) and re-
define that area as the print area.

My question is how do I "get" the extract range, so I can select it
and define the print area? Is there functions or macro commands that
will allow me to do this?

Any comments or suggestions would be greatly appreciated.

---------------------
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

Technical Details

Message-ID: <1992Dec19.153406.10405@news.acns.nwu.edu>

Path:

arc1-ca.pugleaf.net!sparky!uunet!olivea!spool.mu.edu!sdd.hp.com!usc!news.service.uci.edu!network.ucsd.edu!news.acns.nwu.edu!casbah.acns.nwu.edu!stubaker

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!olivea!spool.mu.edu!sdd.hp.com!usc!news.service.uci.edu!network.ucsd.edu!news.acns.nwu.edu!casbah.acns.nwu.edu!stubaker
From: stubaker@casbah.acns.nwu.edu (Stuart Baker)
Newsgroups: comp.apps.spreadsheets
Subject: Excel: Extract Range Macro Question
Message-ID: <1992Dec19.153406.10405@news.acns.nwu.edu>
Date: 19 Dec 92 15:34:06 GMT
Sender: usenet@news.acns.nwu.edu (Usenet on news.acns)
Organization: Northwestern University, Evanston Illinois.
Lines: 19
Nntp-Posting-Host: unseen1.acns.nwu.edu