Method one: How to run a VBA sub procedure from the Developer and View tabs in Excel Excel’s .xlsx ribbon has been with us for a long time, but you might not know about the Developer tab because ...

The procedure is in the downloadable .bas files, which you can import into the Personal.xlsb file’s Module 1. If you enter the code manually, don’t paste from this web page.

So, my stored procedure returns all the desired data in columns with the column titles and everything. That report now needs to print as an Excel file when the user clicks on a button on a form ...

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. <BR><BR>Now I want to ...

The procedure in Excel is easy to learn, though it is important to keep in mind a couple of caveats. Superscript in a Whole Cell or Multiple Cells. Highlight the cell(s) you want to make superscript.

So if you want all Excel files to show, run the same procedure in Excel. A BETTER SOLUTION: CUSTOM-PRINT VIEWS IN EXCEL When a reader asked how to create a group of custom views of a spreadsheet ( ...