Hi,
I have 2 sheets that are used as source data. And I have a form where I
import from the source sheets data. After modifications, I copy back the
data in the source sheets. The problem is that cells formatted as
monetary values with decimal seem to copy as text. So when I try to do
automated mathematic functions in vba, it says incompatible type. And
when I debug in VBA, I see that the monetary values have quotation
marks in the yellow debug mode as if it was quoted as text. Is there a
way to prevent this side effect?
Thx!
Werner
--
Werner
------------------------------------------------------------------------
Werner's Profile:
http://www.excelforum.com/member.php...o&userid=24304
View this thread:
http://www.excelforum.com/showthread...hreadid=386446