Thread: problem with..end with selection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pierre via OfficeKB.com[_2_] Pierre via OfficeKB.com[_2_] is offline
external usenet poster
  
Posts: 122
Default problem with..end with selection
Hi experts,

i have this simple code but it does not seem to work.

With Sheets("Output")
.Visible = True
.Range("A1:F56").Select
.PrintPreview
.Visible = False
End With

I just want a preview of the selected range("A1:F56")......

can anybody help me please ?
Thanks,
Pierre


--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote