Hi all,
in an addin, i have the following simple code:
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).Dim rngMin As Range Dim minVal As Double minVal = WorksheetFunction.Min(Selection) Set rngMin = Selection.Find(minVal, lookat:=xlWhole) rngMin.Select
I tried lookin:=xlFormulas/Values but had no luck.
Anyone got a clue what I should change here? Thanks
Bookmarks