Change Copy to what?

[Bob Vance]

In my Private sub I have Copy, What if I only want to copy data and not the
format what would I change it too?
--
Thanks in advance for your help....Bob Vance
..
..
..
..

 

[Paul B]

Bob, don't know what you have in your code, but could you use something like
this?
Range("A1:A200") = Range("B1:B200").Value


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **