| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the row number in macro
Sorry for the misleading.
Color which row is depend on the weekday. For instance, if today is Monday, fill "A3:D3", "A6:D6", "A11:D11", "A20:D20", Tuesday fill "A51:D51"...etc. The problem is, if there are some new rows must be inserted, say four new rows insert to row 2, 5, 9 and 15, then I need to amend all the code, i.e Monday as "A4:D4", "A8:D8", "A14:D14", "A24:D24", Tuesday to "A55:D55"...etc, very inconvenient. Any idea? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| Macro to change row number within formula | Excel Programming | |||
| Macro to change a number to text | Excel Programming | |||
| Macro to change a number to text | Excel Programming | |||
| Macro to change a number to text | Excel Programming | |||
![jimmy[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
