Dire need of help TRUE instead of numbers

[braindiesel]

I have a large excel file that I have been working on for some time. Now on more than one occasion, I will put in code that should work, but instead of yielding a number, it gives me the result of TRUE.

Am I missing a checkbox somewhere? The code is fine, or seems that way.

The instances are when I copy and paste as values
Range("namedRange").value = range("namedRange").value

and now a recurring issue has come up using a userform combobox index. If I pick the third item, instead of getting a 3, I get TRUE.

Any suggestions would be greatly appreciated.

 

[craig.penny]

Have you tried pasting the format too?

Range("namedRange1").value = range("namedRange2").value

Range("namedRange1").NumberFormat = range("namedRange2").NumberFormat

 

[Andrew Poulsom]

Can you post some real code that behaves like you describe please?