View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cottage6 cottage6 is offline
external usenet poster
 
Posts: 108
Default Use counter to copy formulas

I have a named range "storecntr" that gives me the number of stores on a
worksheet. A formula is entered into cell A2 of another sheet that needs to
be copied down for all the stores. I want to use storecntr to tell how many
rows to copy the formula down, but as usual I'm having trouble because I
swear I have no logic. Any help would be appreciated. Thanks.