I will point out a few additional notable points:Ĭatching the error as done by chris nielsen is a good practice, probably mandatory if using (although it will not suitably handle case 2 above).
Ws2.Range("E2").Formula = CVErr(xlErrNA) ' Use whatever you want
If the ActiveSheet is Sheet1, then using Range("D2") without qualifying it will be searching for Sheet1!D2, and it will throw the same error even if the sought-for value is present in the correct Range.Ĭode accounting for this (and items below) follows: Sub srch() The value is actually not present (pointed out by chris nielsen). The error you are getting is likely due to the sought-for value Sheet2!D2 not being found in the searched range Sheet1!A1:A65536. Please read this explanation and its conclusion, which I guess will give essential information. The answer your question: the correct way to refer to a different sheet is by appropriately qualifying each Range you use.
0 kommentar(er)
