How to Change The Default Printer Using VBA in Microsoft Excel 2016

Hi There! Is your default printer situated in the far corner of the office? Want to print your sheet from the printer by your side? You can c...

Conditional formatting depending on a cell comment using VBA in Microsoft Excel

Question: How can I make a conditional formatting depending on a cell commentary? Answer: Insert the following code into the standard module Formula...

Change text in header when printing using VBA in Microsoft Excel

Question: How Change text in header when printing . Place the code below into a regular Module. Sub VariableRow() Dim intCount As Integer, in...

Calculations with one thousandth fractions of seconds by Custom Function using VBA

Question: Calculations with values in the area of tenthousandth of a second are to be done Answer: Insert the following code in the appropriate mo...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.