print macro to filter search form

Hi all,
I have a search form that finds results by filtering the original
table.  It is adapted from http://allenbrowne.com/ser-62.html .  All
my search boxes are text boxes on my version. I need to be able to
print the records that the search retrieves.  The form is a continuous
form.  I know how to set up a print macro if searching with a Query,
but I have many criterion to search for and the filter was the best
choice.  Additionally I am having problems with the Query code
itself.  Anyways, Is there any way to print out a report of filtered
results like that?  Thank you for your time in advance.
M

0
michelleumich
7/6/2007 5:30:45 PM
access.forms 6864 articles. 2 followers. Follow

13 Replies
923 Views

Similar Articles

[PageSpeed] 43

To print the same records as filtered in your form, you can use the form's 
Filter as the WhereCondition for OpenReport.

The basic idea is:
    Dim strWhere As String
    If Me.FilterOn Then
        strWhere = Me.Filter
    End if
    DoCmd.OpenReport "Report1", acViewPreview, , strWhere

If the filter includes Lookups associated with combos (applies to Access 
2002 and later only), you may need to craft the query for the source of your 
report by aliasing the tables so they match the lookup names used in the 
filter string.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"michelleumich" <mahampto@umich.edu> wrote in message
news:1183743045.486940.258010@o61g2000hsh.googlegroups.com...
> Hi all,
> I have a search form that finds results by filtering the original
> table.  It is adapted from http://allenbrowne.com/ser-62.html .  All
> my search boxes are text boxes on my version. I need to be able to
> print the records that the search retrieves.  The form is a continuous
> form.  I know how to set up a print macro if searching with a Query,
> but I have many criterion to search for and the filter was the best
> choice.  Additionally I am having problems with the Query code
> itself.  Anyways, Is there any way to print out a report of filtered
> results like that?  Thank you for your time in advance.
> M 

0
Allen
7/7/2007 1:01:29 PM
Allen,
Thank you so much for your help.  I understand the idea of what you
have given me but I am still relatively new to code and such so I was
wondering where to put this.  Would this go in the form code?  That is
my best assumption.  I have inserted it as such so far:

Private Sub Cmd_Click()
Dim strWhere As String
    If Me.FilterOn Then
        strWhere = Me.Filter
    End If
    DoCmd.OpenReport "QueryMultiValueSearhForm", acViewPreview, ,
strWhere
End Sub


After doing this, how would I configure my Print command button on the
form? Would I set up a macro (attaching it to the command button) to
print the report?
Thank you so much,
M

0
michelleumich
7/9/2007 2:25:17 PM
What is the name of your Print command button?

Use that name instead of "Cmd" in the very first line of your code, i.e. the 
code can go into the Click event procedure of your button.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"michelleumich" <mahampto@umich.edu> wrote in message
news:1183991117.194806.313890@n60g2000hse.googlegroups.com...
> Allen,
> Thank you so much for your help.  I understand the idea of what you
> have given me but I am still relatively new to code and such so I was
> wondering where to put this.  Would this go in the form code?  That is
> my best assumption.  I have inserted it as such so far:
>
> Private Sub Cmd_Click()
> Dim strWhere As String
>    If Me.FilterOn Then
>        strWhere = Me.Filter
>    End If
>    DoCmd.OpenReport "QueryMultiValueSearhForm", acViewPreview, ,
> strWhere
> End Sub
>
>
> After doing this, how would I configure my Print command button on the
> form? Would I set up a macro (attaching it to the command button) to
> print the report?
> Thank you so much,
> M
> 

0
Allen
7/9/2007 2:56:19 PM
Allen,
I posted the code you gave me into the click event procedure of the
command button, and I am receiving an error.  "access can't find the
macro dim strwhere as string if me.."  Did I enter the code
incorrectly into the on click of the command button?
M

0
michelleumich
7/9/2007 3:08:56 PM
Set the commnd button's On Click property to:
    [Event Procedure]

Then click the Build button (...) beside the property.
Access opens the code window.
The code goes in there.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"michelleumich" <mahampto@umich.edu> wrote in message
news:1183993736.978291.186240@22g2000hsm.googlegroups.com...
> Allen,
> I posted the code you gave me into the click event procedure of the
> command button, and I am receiving an error.  "access can't find the
> macro dim strwhere as string if me.."  Did I enter the code
> incorrectly into the on click of the command button?
> M
0
Allen
7/9/2007 3:26:12 PM
Allen,
Thanks again.  Your help worked.  However, I have encountered a new
problem. When I search with the form filter and then click my print
command button, I get another error.  "Query must have at least one
destination field".  I then clicked "Debug" and it took me to this
line of code:

DoCmd.OpenReport "QueryMultiValueSearchForm", acViewPreview, ,
strWhere

Yes, "QueryMultiValueSearchForm" is the title of my report.  I'm aware
this is a really really bad name for a report but the logic was to
keep consistent with a line of forms that I had been working with.
(In the process of developing this database I have made over 20 forms
and needed a way to keep them and all their "accessories" straight)
Anyways, Is the error becuase the title of my report is bad? Now that
I know the form associated with this report is the "final copy" I will
probably be changing the Report name anyways.  What else could cause
the error?
Additionally, when I received this error I went into the report itself
to see if there was something I did that caused the error (such as
attached a macro to it while working with it earlier that was no
longer needed) and I got the same error "Query must have at least one
destination field."  The error is definately in the report.
With this, I tried to make a new report since it is quite obvious
something is wrong with the one I attached it to.
Access is allowing me to create a Report in Design view, but when I go
to make a report with the Report Wizard I receive yet another error
"This feature has been disabled...'follow these steps to enable it'.
"  Anyways, I follow the steps that they give and the Report Wizard
has not been disabled! What could I have done to cause this?  I don't
really know how to make a report in Design view and the Wizard is much
easier anyways. Again, thank you so much for your help.  You are very
concise which I appreciate.
Thanks,
M

0
michelleumich
7/9/2007 4:21:11 PM
Allen,
I had an additonal question for you considering I am using an adapted
version of your subform, you would probably be able to help me.
I have changed my tables since creating the adapted form- and I was
wondering if you could help me with re-adapting the form (since I am
still relatively new to Access) to my new tables.
The form I originally based the continuous search form on had
duplicate information- information that was contained in other tables
and all of it had a many-many relationship.  It took a while for me to
figure it out, but after only after adapting your subform I finally
figured out how to link the relationships between all of the tables.
Anyways, I ended up moving a lot of  the original table into a linking
table- one you would use for a many-many relationship.  I was
wondering if you would know how to search for data using the
relationships and with multiple tables.  If you need to know how my
tables are laid out more specifically to answer the question (if you
can), let me know. You have been a lot of help already. Thank you so
much,
M

0
michelleumich
7/9/2007 6:21:59 PM
1. Open the report in design view.

2. Open the properties box, making sure it's Title reads "Report" (i.e. you 
are looking at the properties of the report, not of a text box or section.)

3. On the Data tab, the Record Source property contains the name of the 
query the report is using. Go to the Database window, the queries tab, and 
open that query in design view. You have no fields in the output grid.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"michelleumich" <mahampto@umich.edu> wrote in message
news:1183998071.257258.250310@c77g2000hse.googlegroups.com...
> Allen,
> Thanks again.  Your help worked.  However, I have encountered a new
> problem. When I search with the form filter and then click my print
> command button, I get another error.  "Query must have at least one
> destination field".  I then clicked "Debug" and it took me to this
> line of code:
>
> DoCmd.OpenReport "QueryMultiValueSearchForm", acViewPreview, ,
> strWhere
>
> Yes, "QueryMultiValueSearchForm" is the title of my report.  I'm aware
> this is a really really bad name for a report but the logic was to
> keep consistent with a line of forms that I had been working with.
> (In the process of developing this database I have made over 20 forms
> and needed a way to keep them and all their "accessories" straight)
> Anyways, Is the error becuase the title of my report is bad? Now that
> I know the form associated with this report is the "final copy" I will
> probably be changing the Report name anyways.  What else could cause
> the error?
> Additionally, when I received this error I went into the report itself
> to see if there was something I did that caused the error (such as
> attached a macro to it while working with it earlier that was no
> longer needed) and I got the same error "Query must have at least one
> destination field."  The error is definately in the report.
> With this, I tried to make a new report since it is quite obvious
> something is wrong with the one I attached it to.
> Access is allowing me to create a Report in Design view, but when I go
> to make a report with the Report Wizard I receive yet another error
> "This feature has been disabled...'follow these steps to enable it'.
> "  Anyways, I follow the steps that they give and the Report Wizard
> has not been disabled! What could I have done to cause this?  I don't
> really know how to make a report in Design view and the Wizard is much
> easier anyways. Again, thank you so much for your help.  You are very
> concise which I appreciate.
> Thanks,
> M 

0
Allen
7/10/2007 1:39:28 AM
Create a query using the tables your fields are now in.

Use that query as the Record Source for your search form.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"michelleumich" <mahampto@umich.edu> wrote in message
news:1184005319.237759.160150@g4g2000hsf.googlegroups.com...
> Allen,
> I had an additonal question for you considering I am using an adapted
> version of your subform, you would probably be able to help me.
> I have changed my tables since creating the adapted form- and I was
> wondering if you could help me with re-adapting the form (since I am
> still relatively new to Access) to my new tables.
> The form I originally based the continuous search form on had
> duplicate information- information that was contained in other tables
> and all of it had a many-many relationship.  It took a while for me to
> figure it out, but after only after adapting your subform I finally
> figured out how to link the relationships between all of the tables.
> Anyways, I ended up moving a lot of  the original table into a linking
> table- one you would use for a many-many relationship.  I was
> wondering if you would know how to search for data using the
> relationships and with multiple tables.  If you need to know how my
> tables are laid out more specifically to answer the question (if you
> can), let me know. You have been a lot of help already. Thank you so
> much,
> M
0
Allen
7/10/2007 1:40:37 AM
I thought the method we used was to avoid using a Query?

0
michelleumich
7/11/2007 4:29:21 PM
If you need to draw multiple fields from multiple tables, a query is how you 
do that.

The example suggests omitting the critiera from the query (i.e. you build 
the form's Filter string dynamically).

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"michelleumich" <mahampto@umich.edu> wrote in message
news:1184171361.290232.215810@r34g2000hsd.googlegroups.com...
>I thought the method we used was to avoid using a Query?
> 

0
Allen
7/12/2007 1:45:36 AM
Allen,
Thank you for your help.  However, I am still relatively new to Access
(I have been using it only a month and have developed a database over
this summer).  I also have no programming background.  Because of
this, I do not know a lot of technical terms associated with the
program.  What does building the Form's filter string dynamically
mean?  I assume "the example" is the one I refrenced in the first
post. Is that correct?  Unfortunately becuase of my limited background
I may need a little more guidance to understand what you mean.
M

0
michelleumich
7/12/2007 3:17:41 PM
Yes: the example at:
    http://allenbrowne.com/ser-62.html
shows how to build the filter string in code, and apply it as the Filter of 
the form.

You can download it and test it out, and then pull it apart to see how it 
works.

Or there's some simpler examples here:
    http://allenbrowne.com/casu-08.html
    http://allenbrowne.com/casu-15.html

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"michelleumich" <mahampto@umich.edu> wrote in message
news:1184253461.710375.206030@22g2000hsm.googlegroups.com...
> Allen,
> Thank you for your help.  However, I am still relatively new to Access
> (I have been using it only a month and have developed a database over
> this summer).  I also have no programming background.  Because of
> this, I do not know a lot of technical terms associated with the
> program.  What does building the Form's filter string dynamically
> mean?  I assume "the example" is the one I refrenced in the first
> post. Is that correct?  Unfortunately becuase of my limited background
> I may need a little more guidance to understand what you mean.
> M 

0
Allen
7/12/2007 3:37:12 PM
Reply:

Similar Artilces:

Displaying a stored image on a form
I created an OLE Object type field in a table and then I inserted an graphic file (JPG). I then created a form on which I want to display my graphic file. I tried to display the graphic in a bound object control but the contol only displays the file name or an icon on the form. How can I get the actual graphic to display? I can display an image on a form but this is only a link to a graphic file and if I move or delete the original graphic file the database connection is lost. I want the image to be stored in the database so there is no linkage to outside files. Has anyone done th...

Control of exit from a Form opened within a subroutine
A DoCmd.OpenForm statement occurs part way down my Access 2000 subroutine "Prcs". The opened form presents the user with some screen info from which he/she must decide which of the two command buttons "Continue" and "Quit" should be clicked. "Quit" sends execution control elsewhere while "Continue" is designed to continue processing within Prcs. Sub Prcs tested vb code ' Includes evaluation of "strCrit" DoCmd.OpenForm "frmShowinfo", , , strCrit more tested vb code end sub I've not found a way to stop contr...

Popup Form question
How can I set a pop-up form to only take one record? I have a popup form (single form) to take some customer info however when if they tab past the last field all the data disappears. Anyway to prevent this? Thanks in advance D "Dave" <dave@accessdatapros.com> wrote in news:95EBA52D-5DC8-4333-A18F-9A7EA4B65D77@microsoft.com: > How can I set a pop-up form to only take one record? > I have a popup form (single form) to take some customer info > however when if they tab past the last field all the data > disappears. Anyway to prevent this? > > Thanks in ...

help me set up a Event Macros
i am looking to use more than 3 colors in my spreadsheet i can do the conditional formatting for 3 colors but need help to use 5 colors. I am new to this so please tell me how to do this thank -- Message posted from http://www.ExcelForum.com You could use a worksheet_change event: rightclick on the worksheet tab that should have this behavior. Select View code and paste this in the code window. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim myColor As Long If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Me.Range("a:a")) I...

How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet" does not have a page 2 - If there are 10 sheets & each one contains 2 pages of data, each page is still sequentially numbered 1-20. One option is to select the area to be printed on each sheet and go to File>Print Area>Set Print Area. Once you do this for each sheet, go to the Print dialog box and select Entire Workbook. HTH |:>) "sflower" wrote: > ...

Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...

I need a Macro that will open workbooks and run a different Macro.
Hello, Is there a way for a macro to open all workbooks in a folder and then run another macro? I have the 'other macro' written already, I just need a macro that will open 200 spreadsheets - (they are not in the same folder but I can move them if needed, they are in the same directory) - , one at a time, then run my macro, then save each spreadsheet. I've asked a similar question of this forum (specifically dealing with txt files - thank you Jim Cone.) and I've tried to modify that Macro so it will open *.xls files but I can get it to work. Any help with this will...

UCE content filter not working
We are running Exchange 2003 with SP2 and I'm trying to get the uce content filter to work. Below is the xml file which I do save as unicode. I can't get the Inside Elderhealth part to work. I restarted the SMPT server in Exchange System Center and the SMTP service from Services. <?xml version="1.0" encoding="UTF-16"?> <CustomWeightEntries xmlns="http//schemas.microsoft.com/2005/CustomWeight"> <CustomWeightEntry Type="Both" Change="9" Text="viagra"/> <CustomWeightEntry Type="Both" Change=...

Advanced Filtering
Hello, I've got a worksheet with four columns, one of which is a user name. I would like to take all the user names that contain numbers (and their respective data) and put it into a separate worksheet. So far, I haven't had any luck doing this with any combination of wildcard operators. The format of the user names are two or three letters and then 4 numbers, or they are entirely text. So the list has data like abc1234, ab1234 and abcdef. I want all the abc1234 and ab1234 entries in a separate list. Any suggestions? Thanks in advance. Maybe you could use a helper column and filt...

Form Locked !
Hi, I created a form using the wizard based on a query, everything looks ok but i cannot enter data into the form as it appears to be locked ? what have i done wrong, i been trying to solve this for 2 hours now - please can you HELP!!! blake7, One common reason is the query used for the form. Open the query and see if you can add a new record to the query. If you can't, have a look here: http://www.allenbrowne.com/ser-61.html Jeanette Cunningham "blake7" <blake7@discussions.microsoft.com> wrote in message news:808F403F-8822-4619-9F50-DCA5E8B57DC1@microsoft.com... ...

Outlook Junk Filter is filtering good emails sometime
I have a co worker that sends me emails all the time, some time the junk email filters it, and sometimes it does not. I would like it to never filter emails from his address. Using outlook 2003 with exchange 2003 Frank. Can you add them to the Safe Senders list? "WizardOnTheRun" <frank.perryman@dadeservice.com> wrote in message news:1186663659.958194.221190@b79g2000hse.googlegroups.com... >I have a co worker that sends me emails all the time, some time the > junk email filters it, and sometimes it does not. I would like it to > never filter emails from his addre...

How to 1. Jump to a specific page (in a massive document) based on a search then 2. Copy and paste an string of characters a few lines above it.
BACKGROUND/CONTEXT I am working from a very large word document, approximately 1000 pages long. Each page has one 'article' on it. I am currently doing something manually, which I would love to do using a macro. I am populating a table (which happens to be in an Excel spreadsheet) One column is the Article number 'xxxxx'. One of the other columns is a 'Topic' which is typically three alphanumeric characters (like AA1, AD4, BB4 DO6 etc.) PROBLEM/TASK This is what i have to do Step 1 - Jump to the page with the article number. Achieved by p...

Default form in Public Calendar folder
I have a calendar in the public folders. Is there any way so that when the user clicks on the "New" button in Outlook that the default form that opens is a "Meeting Request" as opposed to an appointment? Thanks! Sylvia <sylvia@nospam.com> wrote: > I have a calendar in the public folders. Is there any way so that > when the user clicks on the "New" button in Outlook that the default > form that opens is a "Meeting Request" as opposed to an appointment? I don't think so, but you can certainly click the down-arrow next to the New ...

Print Preview using CPreviewDC
Hi there, I have a problem trying to implement a print preview function. Yet the printing itself is no problem. I have this chart control with a method m_graph.PrintGraph(CDC *pDC) which outputs the data to the CDC object. Now I want to do Print Preview similarly using the CPreviewDC class mentioned in the MSDN Documentation instead of the CDC class. How do I setup the CPreviewDC object without a print dialog? And after I have printed the content into the CDC class how do I display the print preview? ...

Unwanted Code Being Added to Form
This is a multi-part message in MIME format. ------=_NextPart_000_0085_01CAB57D.00862050 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Access 2007 sp2. I thought I seen it all. For some reason code was added to the OnClose of one of my forms that I = DID NOT put there! The code is a 1 liner using the NavigateTo command.(irrelevant I = believe). I recall testing using custom Navigation Panes about a year ago but = abandoned it. I recall having code in the OnClose of my form(s) that switched to a different Custom = Nav Pan...

Multiple combo boxes on a form
I have a form based on two tables. I would like a combo box for a field from each table that will fill in various fields from the relevant table. Does anyone have any suggestions? On Fri, 17 Aug 2007 23:58:37 GMT, "Malt" <u36720@uwe> wrote: >I have a form based on two tables. I would like a combo box for a field from >each table that will fill in various fields from the relevant table. Does >anyone have any suggestions? Why would you want to do that? It sounds like you're trying to store data from one table redundantly into a second table. This is essentially ...

forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view. All the tables, queries, and macros are there. When I open up the database to add data, all the forms are there and can be used. The data is stored. So, it seems that the forms are still there, but just cannot be seen in design view. The database, when I open it up in design view, says Access 2000 file object even though I am using Access 2003 - could that be the problem? Thanks! You cannot open an entire database in Design View. Try opening it normally, selecting a form, and choosing Design View from the V...

Set Print Preview to always show color
It was easy enough to get Publisher 2003 to perform a print preview in black and white using Tools, Commercial Printing Tools. I want to set it back to print preview in color but it refuses to do so. I have jacked around with all of the radio buttons for Any Color, Single color, Process Colors, etc. but nothing seems to work. If anyone can help me out, please do so. -- Thanks Wes Newman How about the printer settings? Are they set to color? The Generic Color Postscript for Commercial Printing has a color choice in the preferences. Paper/Quality tab. Have you checked the printer pre...

inserting text form field in a text box
I'm designing a form that has several text boxes I want to be able to insert a text form field that I can type in different names in when needed, while keeping the rest of the text constant. Every time I go to insert form field from Legacy it is not available. Anybody have a solution. Your subject line has the missing clue. There is no way to insert a legacy form field (text or any other kind) in a text box, footnote, endnote, or header/footer. You can remove the text box and put the field into ordinary text, or you can use a text content control in a text box or elsewhe...

SFO
Hi, We have an issue at the moment and wanted to check to see if anyone else was getting this before rasied a case with Microsoft directly. Basically when using the CRM Email button in SFO to create an email, we click on the Regarding button which brings up a search box where you can search for accounts/users etc. If you have an account in your CRM called Leeds & Birmingham (for example) we perform a search for 'Leeds & Birmingham' and it comes back with no results. If you search for 'Leeds' it finds the account and if you search for 'Leeds &amp;' i...

Pivot table bottom ten filter with conditions
Hi is it possible to have the bottom ten item of a pivot table but excluding specific value(s) eg I have a pivot table with the bottom 10 of cost item 1 -200 $ item 2 -300$ item 3 -0$ .... I would like to exclude item that have a cost = 0$ and have only items greater than 0. thanks Excel 2007 PivotTable Bottom 10, no zeros. Three ways. http://www.mediafire.com/file/kd3dydo3ww4/01_31_10.xlsx thank you for the spreadsheet. ...

Print Receivables Schedule Payments
How can I print the invoice (as in Transaction>>Sales>>TRansaction Entry) of an individual Schedule Payment in Receivables Management? I dont want to print the entire Schedule Invoice used, just a specific invoice (Tools>>Routines>>Sales>>Posted Schedule" Rico: Go to Inquiry>Sales>Transaction by Document or Transaction by Customer. You'll find the invoices in this inquiry window. Highlight the invoice you want print and click on the Document Number link to open the Receivables Transaction. You can print the invoice from there. Frank Hamelly...

How to set form caption / text?
I use MFC Visual C++ 4.2. I am developing an application with main window and a few childs window. How to set each child window text / caption everytime I call DoModal? If I set "Entry Form" then the window I call will displayed with "Entry Form" caption. Thank you. You can use SetWindowText to set it. For a dialog, you should do it any time after its created(IOW, not in constructor). OnInitDialog and after is fine. -- Ajay "Landon" <Landon@discussions.microsoft.com> wrote in message news:F18C3988-E5F2-413E-8CCF-78143066DB29@microsoft.com... >I ...

Not Print Zero values
Howdy, I need to do one of two things: 1) My zero values are hidden but they span down 300 cloumns. Is there away to hide these from printing? 2) The zero values above are a simple currency total between tw fields. I have filled the incrementing formulas down about 300 rows. I there a way to fill in the next incrementing formula [(b2)*(d2)] whe the calulation is made? I want to keep from having 300 growin formulas, I'd rather try to have them incrimentaly auto fill so m print outs wont have 20 extra blank pages. many thanks -- RubberSou ----------------------------------------------...

Print areas #2
Is there any way of getting excel to determine print areas depending on cell content? I have a spreadsheet whose print area needs to change for different data entered and I want to be able to automatically set a print area so the user doesn't need to fiddle with the print area manually. Thanks in advance, Dave ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ If you do not create a print_area then Excel will print the entire active range. If that's not good e...