View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
jimmy[_5_] jimmy[_5_] is offline
external usenet poster
 
Posts: 37
Default 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?