Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Rashid, first checkout that the code doesnot contain illegal characters: (leftovers from copy paste perhaps) set option explicit at the top of your module, then try to compile the code. from your post i quote the lines that look like they contain "leftovers". Note the "¬" character! StartVal = CLng(Application.InputBox(Prom¬pt:="Start with", _ Default:=1, Type:=1)) EndVal = CLng(Application.InputBox(Prom¬pt:="End with", _ Default:=StartVal + 1, Type:=1)) wks.Range("PcDetailsPrint").Pr¬intOut preview:=True if you still have problems tell us on which line it stops. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
Why do I get a print error light trying to print an excel sheet ? | Excel Discussion (Misc queries) | |||
Need Code To Print From Code Modules | Excel Programming | |||
how to use Excel to generate alphabet serially | Excel Worksheet Functions | |||
Help with Mr. Dave Peterson's Code for Consolidating Many Sheets to One | Excel Programming |