Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help with printing an array of worksheets in a workbook based on
data in a specific cell. I have a workbook with 11 worksheets within it. Depending on the information carried forward to the different worksheets, a formula in cell G32 will indicate 'Print' or remain blank. What I am trying to accomplish is a macro that will loop through each of the worksheets and print those that indicate Print in cell G32. Following is what I tried to accomplish this: Sub Print_All_Worksheets_With_Value_In_G32() Dim Sh As Worksheet Dim Arr() As String Dim N As Integer N = 0 For Each Sh In ActiveWorkbook.Worksheets If Sh.Visible = xlSheetVisible And Sh.Range("G32").Value < "Print" Then N = N + 1 ReDim Preserve Arr(1 To N) Arr(N) = Sh.Name End If Next With ActiveWorkbook .Worksheets(Arr).PrintOut End With End Sub However, when I try and run this macro, it stops running and the following line is highlighted: If Sh.Visible = xlSheetVisible And Sh.Range("G32").Value < "Print" Then Any help to correct this problem would be greatly appreciated -- Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print an excel file from command line or "cron" type command ??? | Excel Programming | |||
The Print # command print not all rows from excel sheet to file | Excel Programming | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
Change Print Command or add a new print command | Excel Programming |