LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
revised q on report from tables UKMAN Excel Worksheet Functions 7 April 20th 10 04:15 PM
3rd and last Revised WorkBook Aussiegirlone Excel Discussion (Misc queries) 3 June 21st 09 07:02 PM
REVISED Nexted IF and Countif LPS Excel Worksheet Functions 3 December 5th 07 07:53 PM
Adding in Excel Revised cb New Users to Excel 9 October 8th 07 06:25 AM
n or U Revised ? Blessingspoint Excel Worksheet Functions 1 January 18th 05 08:43 PM


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"