With worksheets("Start")
set rng = .Range("Z3")
End with
i = rng.value
with worksheets(Lables")
set rng1 = .Range("tag" & i)
.PageSetup.PrintArea = "Lables!" & rng1.Address(1,1)
.Printout
End with

--
Regards,
Tom Ogilvy



"mrc1986 via OfficeKB.com" wrote:

What I have is a count function that counts the range A42:A100 in cell Z3 on
a sheet called "Start". What I am trying to do is based on that count
function to select a range that I have defined (tag1,tag2,....tag8) on a a
sheet calld "Lables" and print it based on the results of the count function
in cell Z3. I am hoping to be able to do this in a macro.
Any help will be very appreciated

Thank You

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200605/1