LinkBack URL
About LinkBacks
Hello,
I put vlookup in the column AE and if there is any #N/A in the column the macro should exit and stop.
could anyone help me on this?
Thank you,
Please Login or Register to view this content.
Sudharshan
To find the rows with vlookup value #N/A
Hello,
I put vlookup in the column AE and if there is any #N/A in the column the macro should exit and stop.
could anyone help me on this?
Thank you,Please Login or Register to view this content.
Sudharshan
Try this...
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hello,
I have some #N/A's in column AE but this code is changing the whole column with "#VALUE!" and it pops the message "No File exists".
Can you please help me on this.
Thank you for the help.
Please understand my code doesn't changing anything from your original.
Originally Posted by sudharshan86
Hello,
I put vlookup in the column AE and if there is any #N/A in the column the macro should exit and stop.
could anyone help me on this?
Thank you,Please Login or Register to view this content.
Sudharshan
"=VLOOKUP(B2,'" & sourcesheet.Name & "'!$A1:$D" & SourceLastRow & ",4,0)"
replace your code with the above statement and it will probably work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks