| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Print Pages 1 to 5 with "5" being a reference to a =count
I would really appreciate help with the VB issue outlined below:
1. I have a print area of 10 pages 2. Often only 1 or 2 pages really need to be printed 3. The number of pages to be printed is the result of a "=count" formula in cell A1 of Sheet1 4. Below is the macro I recorded, can you help edit to solve the problem? Sub Macro3() ' ' Macro3 Macro ' ' ExecuteExcel4Macro "PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)" End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
| Print "freeze panes" on succeeding pages? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Excel VBA - go to worksheet "name" based on a cell reference ="Name" | Excel Programming | |||
| What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming | |||
Linear Mode
