View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default Revised btnprint1_click()

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