View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Dean Jay Dean is offline
external usenet poster
 
Posts: 154
Default MACRO TO REPEAT FORMULA



I need a macro that will apply an array formula,say
= {SUM(if(....))}
across the Range E20:N20, and repeat the process after every 10 rows
all the way down to the end of the sheet.

Any assistance would be appreciated. Thanks!

Jay Dean.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!