Your code should work unless you're looking to pull out numbers that are
embedded as part of a formula. I have a SUM function in A1 and when I run
your code it places the value (not the formula) in cell B1.

Can you provide a little more detail?
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

"Antonis" wrote in message
...
Hi I am using this code to copy cell A1 to cell B1

Range("B1").Value = Range("A1").Value

How can I copy only the numbers inside the cell without
copying any functions or formulas insideit?

Thanks for your help