Macro doesn't work with floating point numbers

**DNQT** · 05-10-2012, 03:35 PM

I already create this macro working well on this worksheet except the part that in DIVERSIFIED category, we use floating point numbers and it can't be read into the Matrix . Is there a way to fix this problem? Thanks alot.

RM.xlsm

**protonLeah** · 05-11-2012, 03:32 PM

1. You did not DIM (declare any of your variables, therefore they are all type Variant)
2. You did not include any remarks in your code to explain what you are doing.
3. You did not identify the "matrix".

**StevenM** · 05-11-2012, 04:47 PM

4. You did not point to any part of the code where you suspect there might be a problem.

**DNQT** · 05-14-2012, 03:36 PM

well, the code worked absolutely fine if those columns in DIVERFIED category filled with interger numbers. But when they are changed to floating numbers, it doesn't work.