View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
URGENT URGENT is offline
external usenet poster
 
Posts: 5
Default Copy & Paste formulas

I have created a page of formulas and I would like to copy and paste them to
another spreadsheet, when I do this the location changes. ex(c3:c8 changes to
c23:34) How do I prevent this from happening. Also in the formula I have a
month, can I change this month before I paste to a new month without going to
each formula and change it manually.