Copying some cells while not disturbing the formula refrences

[abdul43]

hi
i want to copy some cells which contain formulas when i copy them and after pasting the formula refrence changes and different values come to different cells.
so i want to copy these cells without disturbing the formula references given in these cells and copy the values with the same ranges. i hope that i have explaind well if not perdon me but please kindly help me.

 

[MarkCBB]

HI there,

you can try using this for the paste.

 ActiveSheet.Paste Link:=True

 

[hiker95]

abdul43,

Select the range of cells.

Click on Edit, Copy, or CTRL + C, or click on the CTRL key and click on the C key

Then click on the cell to where you want to paste the values, and click on Edit, Paste Special, Values and click on the OK button.

 

[abdul43]

this method copy the data with out formulas but i want to keep the same formulas with out any reference change.

 

[abdul43]

abdul43,

Select the range of cells.

Click on Edit, Copy, or CTRL + C, or click on the CTRL key and click on the C key

Then click on the cell to where you want to paste the values, and click on Edit, Paste Special, Values and click on the OK button.

this method copy onlly values but i want to keep function only without any reference change.

 

[abdul43]

HI there,

you can try using this for the paste.

 ActiveSheet.Paste Link:=True

where to put this code sir

 

[MarkCBB]

HI there Abdula43,

here is a quick solution to your challange, copy the range, then hold ctrl, Alt and V, then select paste links

 

[abdul43]

HI there Abdula43,

here is a quick solution to your challange, copy the range, then hold ctrl, Alt and V, then select paste links

it does'nt work