Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to get Match property of worksheetfunction
I searched google groups for this, but all of the questions i found had to do
with using match with the 3rd argument being 0. Therefore if a match is not found, it returns an error. However, I was trying the match function without the 3rd argument. I was trying, and doing it successfully from the immediate window to find where in my range to insert some rows. However, once the code is running, neither worksheetfunction.match nor application.match works. I did try, while still in debug mode, to do a match wtih a value that would be found. This did return a correct value. What I am trying to do: iMatchStore = worksheetfunction.match(sStaffStore, rngCEIWork) and then later rngCEIWork.Range("a1").offset(iMatchStore).resize( iStoreDiff) _ .entirerow.insert shift:=xldown I was unable to find any discussions on google groups that specifically addressed the issue of when an exact match was not being sought. Perhaps it was because I couldn't think of how to phrase it. But, given these circumstances, does anyone know of a work around. Of course I could just loop through the range and find it myself, but would prefer it if I could do it this or a similar way. Thanks. -- Kevin Vaughn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Unable to get the VLookup property of the WorksheetFunction class | Excel Discussion (Misc queries) | |||
Unable to match property error | Excel Discussion (Misc queries) | |||
"Unable to get the NormSInv property of the WorksheetFunction clas | Excel Worksheet Functions | |||
Unable to get the Text property of the WorksheetFunction class | Excel Programming | |||
Unable to get the Vlookup Property of the WorkSheetFunction Class | Excel Programming |