Thread: copy and paste formulas that apply to multiple worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Executor Executor is offline
external usenet poster
  
Posts: 74
Default copy and paste formulas that apply to multiple worksheets
Hi,

I have tried your problem and do not get it.
I guess that there is a problem in the formula.
I have tried
=SUM(Sheet1:Sheet7!A1)
this copies correctly
If i try
=SUM(Sheet1:Sheet7!$A$1)
the problem occurs

Hoop this helps,

Executor

Reply With QuoteReply With Quote