In this article, we will create a macro which will return computer and user name for the logged in user. In this example, we want to extract computer...
If you want to insert certain information in the header / footer of the worksheet like the file name / file path or the current date or page number, y...
To reverse the character order, create and add a Custom Function to the Insert Function dialog box: 1. Press Alt+F11 to open the VBE. 2. In VBAPro...
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...
Question: How can I make a conditional formatting depending on a cell commentary? Answer: Insert the following code into the standard module Formula...
With the procedures below you can use DAO to retrieve a recordset from a closed workbook and read/write data. Call the procedure like this: GetWorks...
Question: How Change text in header when printing . Place the code below into a regular Module. Sub VariableRow() Dim intCount As Integer, in...
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.
