Instead of just paste use EditPaste Special and choose values. This pastes
only the value and not the formula

Cheers Lyn

"Louie" wrote:

Hi there, I need some help copying data from book to book without copying the
formulas on the cells, when I copy a column, it brings the formulas with it
and it gives me an error, is there a way to copy only the Data?
thanks for your help.

--
Louie