LinkBack URL
About LinkBacks
I have attempted this piece of code, but I am little confused as to the syntax for the IsError() function.
Any assistance would be helpful!
Please Login or Register to view this content.
I have attempted this piece of code, but I am little confused as to the syntax for the IsError() function.
Any assistance would be helpful!
Please Login or Register to view this content.
iserror does not work with an array or multiple-cell range but you can use
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
unfortunately, when I place a vlookup in column A that evaluates to an error, the "there were errors" prompt does not come up when I run the macro; the other one comes up insteadOriginally Posted by JosephP
care to post a sample? the code works for me
https://dl.dropboxusercontent.com/u/69651453/Book3.xlsm
wrong sheet name-you need
and notPlease Login or Register to view this content.
;-)Please Login or Register to view this content.
wrong sheet name-you need
and notPlease Login or Register to view this content.
;-)Please Login or Register to view this content.
arrgggggggggggghhhhhhh!!!!!!!!!!!!!!!
btw what does the on error go to zero achieve here?
nothing-I wasn't sure if that was really the end of your actual sub so I thought I'd add it just in case
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks