Copying cell data without the formula
 

Hello,
I would like to copy a cell range (Column D) from 1 sheet and paste t
the same cell range of another sheet without carrying over the formula
Any help would be great !

Thanks,
Ore

--
Ore
-----------------------------------------------------------------------
Oreg's Profile: http://www.excelforum.com/member.php...nfo&userid=919
View this thread: http://www.excelforum.com/showthread.php?threadid=37970

Copying cell data without the formula
 

Use paste special and paste as values.

Record a macro while doing this manually to see the correct syntax.

HT

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=37970

Copying cell data without the formula
 

Thanks bhofsetz, Worked perfectly

--
Ore
-----------------------------------------------------------------------
Oreg's Profile: http://www.excelforum.com/member.php...nfo&userid=919
View this thread: http://www.excelforum.com/showthread.php?threadid=37970