| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select cells by format with VBA
I'm trying to write a macro to convert 1904 dates to 1900
and vice versa (by adding or subtracting 1462 as appropriate). That's quite simple but as I want the whole worksheet processed at once I want the macro to examine the format of each cell and make the change only where it has a date format. Otherwise other data will be affected. That's beyond my ability. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked Several Worksheets, allow format cells/select unlocked cell | Excel Discussion (Misc queries) | |||
| Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Select format cells Custom but Saves As Specil Why. | Excel Worksheet Functions | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Threaded Mode
