Thread: Macro to Print Pages 1 to 5 with "5" being a reference to a =count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Analyst1 Analyst1 is offline
external usenet poster
  
Posts: 1
Default 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 With QuoteReply With Quote