Help with Macro

Ron Taggart · Jul 17, 2003

I need help developing a Macro to print out a certain page. I have a cell
reference that contains a page number. I want to use that cell reference to
print out a corresponding page.

For example, cell A2 contains the sum 3. I want to print out page number 3
only.

Can you help?

TIA

--
"Knowlege gives weight and accomplishment
gives lustre, but more people see than weigh."
-Earl of Stanhope

Ron Taggart, President
PRINTING CONCEPTS, INC.
4246 Hudson Drive
Stow, Ohio 44224
330-572-8200 Fax: 572-8201
(e-mail address removed)
www.printingconcepts.com

Bill Lunney · Jul 17, 2003

Enter this routine with either the name of a worksheet or an index. E.g.

PrintWorksheet 1
PrintWorksheet worksheets(1).range("A2")
PrintWorksheet "Sheet2"

Public Sub PrintWorksheet(SheetNameOrNum As Variant)
Worksheets(SheetNameOrNum).Activate
ActiveWindow.SelectedSheets.PrintOut
End Sub
http://www.billlunney.com/Excel/FAQ/DisplayFAQ.ascx?ExcelFAQID=205

--

Regards,

Bill Lunney
www.billlunney.com