Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I recorded a simple macro to change the format of a worksheet to "Accounting".
Cells.Select Selection.NumberFormat = "_(* #,##0_);_(* (#,##0);_(* ""-""_);_(@_)" But how do I "deselect" the page after the macro has executed? In other words, when I created the macro I selected the entire spreadsheet, so when I run the macro the entire worksheet remains selected after the macro runs. What code can I put at the end of the macro so that the last cell that was selected when the was run is reselected when it finishes. Or, if there's better code to accomplish the reformatting of a spreadsheet that negates having to reselect the cell I was working in I'd appreciate to have that. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Find formatting in text in cell, insert tags around formatting. | Excel Programming | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Decimal Formatting in Windows English vs European Formatting | Excel Programming |