Find Min Value Error (91)

[Bishonen]

Hi all,

in an addin, i have the following simple code:

Please Login or Register  to view this content.

If the cells are numbers with a decimal point the code struggles to select the cell and returns an error instead(91 - with block variable not set).

I tried lookin:=xlFormulas/Values but had no luck.

Anyone got a clue what I should change here? Thanks

[RHCPgergo]

Maybe the selection is just empty cells?
That way minVal will be 0 and rngMin will be Nothing. So rngMin.Select will throw the error you mentioned.

I've tested it with some numbers and it works for me.

[Bishonen]

Hi RHCPgergo! Thanks for your fast reply. Sadly the problem lies in something else. I wanted to attach a file but am unable due to internet restrictions at my workplace.

Please try to find the max value of those three numbers:

151.369424650939 142.999500243784 173.81723803147

The error should pop up.

Thanks

[RHCPgergo]

Still works, both Min and Max.
Maybe your numbers are not recognized as numbers by excel? They may be recognized as text. (If they are aligned right, they are probably numbers. If aligned left, then it is text.)

[Bishonen]

Sadly those are numbers in my case as well :/ Pretty weird that the same code works for you, while it doesnt for me... Min works - max doesn't.
Thanks for your help anyway! If anyone can come up with a reason why it wont work at my side, then please let me know

[:) Sixthsense :)]

cells are numbers with a decimal point the code struggles

Please share that Number on which the code fails for testing purpose

[RHCPgergo]

In the OP you said that Min doesn't work. So what did you do that it works now? :P

edit: question is directed at Bishonen

[:) Sixthsense :)]

In the OP you said that Min doesn't work. So what did you do that it works now? :P

The above message is for whom?

[:) Sixthsense :)]

After the declaration of the variable add this code and try....

Please Login or Register  to view this content.

Awaiting for the feedback