View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 85
Default Formula Changes when I delete other cells

Good morning,
I have a table set up that uses columns a through e to supply data.
Currently the table is set up on H13:N25.

Here's the dilemma. I need to import this table only into another worksheet
as part of a macro, and when I delete all the other information the cells
change and the formulas change to REF errors.

Is there a way I can import only the table and its formulas into a new
worksheet, while keeping the integrity of the worksheet?