Excel - Printing

I have a sheet used to enter a unit and quantity.  The quantity is then
calculated by the untis and populated on another sheet for forecasting
purposes.  The calculated sheet is formatted to print up to 42 rows of data.
This is to account for the data entry sheet using every single unit.  Most of
the time all the rows are not used. Since it is formatted to show all units it
will print 3 pages.  Many times though there is only data on the first page
but all 3 pages will print.  How do I get Excel to only print the first page
versus all three when less data is entered?

  Jim Thomlinson replied to Glenna

Is setting the print area each time you want to print an option. It only
takes about 10 seconds to do if you have the print area icon on one of your
standard menu's. That is the easiest solution.

There is a relatively simple option that will automatically resize your
print area for you. It relys on the fact that the pirnt area is actually a
named range and you can make named ranges dynamically resize. Here is a link
to dynamic named ranges...

http://www.cpearson.com/excel/excelF.htm#DynamicRanges
--
HTH...

Jim Thomlinson

error with code Excel Hi, I have a code but I get an error because of another piece of Stock Maintenance ?? M Neil " If MsgBox(strPrompt, intbuttons, strTitle) = vbYes Then With Sheets("Stock Maintenance") Range("C3").Copy Sheet4.Range("B7") Range("C4").Copy Sheet5.Range("B7") Range("C5").Copy Sheet6.Range("B7") Range("C6").Copy Sheet7.Range("B7") Range("C7").Copy Sheet8.Range("B7") Range("C8").Copy Sheet9

Outils pour optimiser macro? Excel Bonjour: Je souhaiterais savoir s'il existe des outils et ou techniques pour diagnostiquer et la rapidit = E9 de traitement ou les points de ralentissement. Remerciements et sinc = E8res. Christophe Excel - French Discussions WorksheetFunction (1) PageSetup (1) Worksheets (1) Scenarios (1) Interior (1) Borders (1) Sheets colonne A into "Transitory1" (no formulas). Cells.Select Selection.Copy Sheets.Add.Name = 3D "Transitory1" Range("A1").Select Selection.PasteSpecial Paste: = 3DxlAll, Operation: = 3DxlNone, SkipBlanks: = 3DFalse _ , Transpose: = 3DFalse Selection.Columns.AutoFit 'Run macro "SwapTableShowtime" Range is automaticaly selected 'Then result is saved into "Company Appointments" worksheet and cell A1 is CutCopyMode = 3D False Selection.Delete Shift: = 3DxlToLeft Application.Run "ShowtimeSwapTable" ActiveSheet.Name = 3D "Company Appointments" Range("A1").Select Application.CutCopyMode = 3D False Selection.Font.Bold = 3D True ActiveCell.FormulaR1C1 = 3D "DATE Copy and paste result into "Transitory2" worksheet Cells.Select Application.CutCopyMode = 3D False Selection.Copy Range("A1").Select Sheets.Add.Name = 3D "Transitory2" ActiveSheet.Paste Columns("A:A").Select Selection.NumberFormat first two columns of "Transitory2" worksheet and paste it each time in a new sheet 'named by the company name in cell "B1" (note that a variable Onglet was created) 'Remove column of the company processed For I = 3D 1 To 120 If Application.WorksheetFunction.CountA(Range("B2:B115")) = 3D 0 Then GoTo Suite1 End If Dim Onglet As String Columns("A

clean up code a little Excel Hi I have a copy and paste code I was wondering if there is a it up a little to run it more better. Here is my code. Sub ApplyStock() Range("C3").Copy Sheet4.Select Range("B7").Select ActiveSheet.Paste Sheets("Stock Maintenance").Select Range("C4").Copy Sheet5.Select Range("B7").Select ActiveSheet.Paste Sheets("Stock Maintenance").Select Range("C5").Copy Sheet6.Select Range("B7").Select ActiveSheet.Paste Sheets("Stock Maintenance").Select Range("C6").Copy Sheet7.Select Range("B7").Select ActiveSheet.Paste End Sub Many thanks Mark Excel

Win7 VirtualStore Weirdness with Excel 2002 and earlier Excel I thought I'd share a weird experience I had today in case it saves installer for it - - which registers it as an add-in for all installed versions of Excel - - and tested it. Fine in Windows 2000 in all installed versions of Excel. Boot to Windows XP, fine there too. Boot to Windows 7. Fine in Excel 2010, 2007, and 2003. But Excel 2002 and 2000 were still loading the old version of the add-in. I uninstalled the add-in, made sure it was gone, and reinstalled it. Same problem in Excel 2002 and earlier; still works fine in Excel 2003 and later. I opened the VB editor in Excel 2003 and in Excel 2002

32 bit DLL with 64 bit Excel 2010 Excel We have an app which creates large Excel workbooks. For example, one workbook has 1, 000 worksheets. In other cases there are fewer worksheets but the Excel file can be 80 MB or larger. Since this sometimes crashes Excel 2007 and 2003, I am considering using 64 bit Excel 2010. Would 64-bit Excel be more reliable with workbooks this size than 32-bit Excel? Is 32-bit Excel 2010 any more (or less) reliable with large workbooks than Excel