| Microsoft Office 2003: Excel Basic Excel Macro Tips and Savage Amusement... |
 |
| [Software Tips] [Microsoft Excel] |
| Determine the last active column in a spreadsheet | |||
 Run a macro that has this line:LastCol = ActiveCell.SpecialCells(xlLastCell.)Column If I have a rectangular section of data which I know starts in Row 1, then I use this to find the last column: LastColumn = Range("IV1.")End(xlLeft.)Column And this to find the last row: LastRow = Range("A65000.")End(xlUp.)Row |
|||
| Copy the name of the worksheet tab to a cell in the worksheet | |||
| Run a macro that has this line: ActiveCell.Value = ActiveSheet.Name |
|||
| Show the complete path and filename in the Excel title bar | |||
| Run a macro that has this line: ActiveWorkbook.Windows(1.)Caption = ActiveWorkbook.FullName |
|||
| Have EXCEL execute a macro automatically upon starting EXCEL | |||
| Rename the macro to be AUTO_OPEN. | |||
| Speed up my Macro execution | |||
| Turn off the screen updating during macro execution. Insert this line at the beginning of your macro: Application.ScreenUpdating = False |
|||
| Make the screen stop flashing during macro execution | |||
| Turn off the screen updating during macro execution. Insert this line at the beginning of your macro: Application.ScreenUpdating = False |
|||
| Delete External Links that No Longer Exist | |||
| My worksheet has external links to files that are no longer around. How can I delete the links? This happens all of the time, downloaded a little macro from Microsoft which helps you delete these links. Microsoft has now upgraded the macro to a full blown add-in. | |||
|
