View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek M[_2_] Derek M[_2_] is offline
external usenet poster
 
Posts: 18
Default Pasting formulas advances cell reference

Hi

When i paste special from one cell into another, it advances the cell
reference and i just want an exact match i.e.

A1 formula ='Feb 2010'!C18 but when i paste it into another cell it pastes
it as
='Feb 2010'!D18

The C changes to D, how do i stop this happening?

Thanks for any help in advance

Derek