View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kobus Kobus is offline
external usenet poster
 
Posts: 22
Default VB code for autofill

This will be easy for a VB coder: I have a row range E1:DV1 with concurrent
dates starting Aug 2010 to Nov 2010. I want the rows (lets say 20) below
weekends to be autofilled (Result: Weekends will be visible as columns)
without being affected by subsequent conditional formatting or VB code. The
subsequent code or conditional formatting must autofill between date ranges
obtained from corresponding cells in columns C&D.