Saturday, October 22, 2011

How to Change an Active Cell to Another Cell in Excel 2003


1. Open a new or existing file in Microsoft Excel.
2. Click the 'Tools' menu. Click 'Visual Basic Editor' to open the VBA coding editor. Click the 'Insert' menu item and select 'Module.' This option opens a module that 'attaches' to the Excel spreadsheet. The module is the VBA code that runs in the spreadsheet.
3. Type the following code in the module editor:Range('A1').SelectIn this example, the 'A1' cell is activated. Replace this value with your own cell you want to activate. You can also activate a range of cells. For instance, the following code activates cells from A1 to C1:Range('A1:C1').Select
4. Click the 'Close' button to close the VBA editor. Click 'Save' in the Excel toolbar to save the changes to the spreadsheet.

Blogger news