View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Bruce Roberson Bruce Roberson is offline
external usenet poster
 
Posts: 47
Default Revised btnprint1_click()


-----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