danovkos
06-30-2011, 06:39 AM
Hi all,
i try to search only in visible values (if is value hidden - with autofilter - for me does not exist)
i have this, but this doesnt works and with debugging it return
for value
OKed = error 2042.
but it return this error when is value hidden and also when it doesnt. :(
Set kriesRange = Worksheets("Krieš").Range("a2:a68")
Set VisibleRange2 = kriesRange.SpecialCells(xlCellTypeVisible)
OKed = Application.VLookup(2, VisibleRange2, 1, 0)
any suggestions?
thx a lot
i try to search only in visible values (if is value hidden - with autofilter - for me does not exist)
i have this, but this doesnt works and with debugging it return
for value
OKed = error 2042.
but it return this error when is value hidden and also when it doesnt. :(
Set kriesRange = Worksheets("Krieš").Range("a2:a68")
Set VisibleRange2 = kriesRange.SpecialCells(xlCellTypeVisible)
OKed = Application.VLookup(2, VisibleRange2, 1, 0)
any suggestions?
thx a lot