Search results for query: *

PHV, Your suggestion worked beatifully. Thanks for your help.

I am using a user form to display calculations made using data from a spreadsheet. The code I have written produces the intended result, except I am having trouble figuring out how to format the output to the correct number of decimal places. For example, I would like the value for CalcGmb to...

Thanks, I thought about that, but unfortunately it will not be the default printer. If you have any other ideas please let me know?

I have the following code that I recorded with the Macro recorder in Excel to print a user selection to a USB printer. Application.ActivePrinter = "HP LaserJet P2035 UPD PCL 5 on Ne01:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "HP LaserJet P2035 UPD PCL 5 on Ne01:"...

SkipVought, Thanks for checking up, sorry I haven't responded to my earlier post, but your comments did help me tremendously. Once you mentioned it can't be done via the method I was trying to use I decide to rethink my solution. What I decided to do, which worked fairly well, was set up...

Is there a way to have more than 3 conditions for a cell when using conditional formatting? I tried to write code to add more, but I keep getting a run time on the fourth condition. If it's possible, any suggestions on how to make it work? Thank you in advance for any ideas.

Loomah, Thanks for your input. You are correct, the user would select an option button and depending on which option button they selected, a multiple range selection across several worksheets would be selected. All of the ideas I have come up with on how I might achieve this operation have...

I would like to write code that selects certain ranges from different worksheets within the same workbook and then print that total selection to file or a printer depending on what the user decides. These ranges would be predetermined based on user input. For instance, if option one is...