Thread: Simple Excel 2007 Copy n Paste Problem

Hello,

I have created a custom worksheet that references data on different worksheets. An example of the code is: =AREA10!D78

When I copy the same code and try and paste it into another box eg E30, it changes the code to =AREA10!D106 ???

I just want to keep the same code but place it into different boxes on the same sheet

Any ideas???

Thanks

Chris M

Works !! Thanks for your reply !!