Copy and Paste

C

CLR

I would bet it's because the formula is written with Relative references
rather than Absolute references......like A1 instead of $A$1.........

Vaya con Dios,
Chuck, CABGx3
 
T

Troy

This is true and it has be absolute or else conditional
sum won't work. Is there any solution.
 
C

CLR

Perhaps using RangeNames in your formula instead of directly coding in the
cell references would help........

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
How to paste this down? 3
How to make repeating drop-down lists? 2
Copy and paste slide from one presentation to another presentation gives an error 2
Pages are changing pasted image... 0
Create a dynamic master file 1
Paste to excel from word - auto format problem 1
Copy/Paste (Clipboard) Issues 1

Top