Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a function that has radio boxes as a parameter selection. At each radio box I have a macro assigned which looks similar to below where I assign an upper row and a lower row for a range that I wish to print. The variable was defined as Global and as a String. Sub RadioButtonSelection_1Example() vrow1 = 98 'both vrow1 and vrow2 defined as global and long vrow2 = 109 End Sub Sub printme() vrow1 = "A" & vrow1 'the final product will be A98 in this case vrow2 = "A" & vrow2 'the final product will be A109 in this case If e_agency = True Then Range("A86:A97", "&vrow1:&vrow2").Select Selection.PrintOut Copies:=1, Collate:=True Else Range("&vrow1:&vrow2").Select Selection.PrintOut Copies:=1, Collate:=True End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Ranges based on conditions | Excel Discussion (Misc queries) | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
Setting multiple ranges to print | Excel Discussion (Misc queries) | |||
Print Area ranges print on separate pages? | Excel Discussion (Misc queries) | |||
Print ranges based on cell value | Excel Programming |