View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DEE DEE is offline
external usenet poster
 
Posts: 250
Default prob with dates in VBA

How do i say within a macro taht my dates for a workweek should be static.
like 03/Mar to 7/Mar should remain static for thsi week and when i m in next
week when i open this same sheet it shud give me last week's dates
only..(this is to maintain versions)
but the date has to be dynamic. taht is when i run a macro, when im in a
currenty week it shud show me the current week's 5 days only.... as 5 columns.
but when i open the version of teh sheet that i opened l;ast week it shud
give me last weeks dates only