Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Bruce,
OK! Now I am stumped. One last thing to try. Go into the code and step thru it using the F8 key. This will highlight each line in yellow before processing it. Place the mouse over each of your variable (after processing each line) and see what pops up. If the is a problem - the pop up will show = "" I would be most concerned with Printoption and Printthisrange. Also - do you have Option Explicity at the top of the module? This is a big help in finding problems with variables and code. steve "Bruce Roberson" wrote in message ... -----Original Message----- 1) First not SET Printthisrange = Range("OBACGG").select but SET Printthisrange = Range("OBACGG") I had already done this inside my case selections so I don't see any other places that you were referring to here that need correcting. __________________________________________________ _________ Not Select Case Selectprnrange but Select Case Printoption I did this correction. I didn't understand that the name of the case had to be the same as the object you are testing. I guess that is what you are saying here. Bottom line: I did the correction with Case name, and the other Set Printhistrange without the .select was already correct in the last post. But, where it hangs is still on the same line which now reads per your last post: printthisrange.select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
revised q on report from tables | Excel Worksheet Functions | |||
3rd and last Revised WorkBook | Excel Discussion (Misc queries) | |||
REVISED Nexted IF and Countif | Excel Worksheet Functions | |||
Adding in Excel Revised | New Users to Excel | |||
n or U Revised ? | Excel Worksheet Functions |