LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a macro to repeat based on a conditional formula? moneycop Excel Discussion (Misc queries) 1 April 17th 09 02:25 AM
Repeat a Macro Victoria[_3_] Excel Worksheet Functions 1 September 25th 07 07:11 PM
macro to repeat a formula a set number of rows apart steveo Excel Discussion (Misc queries) 1 July 10th 06 09:21 PM
macro to repeat a formula a set number of rows apart steveo Excel Discussion (Misc queries) 0 July 10th 06 12:46 AM
repeat macro formula to all cells dave glynn Excel Discussion (Misc queries) 8 March 10th 05 08:42 PM


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"