Hi,
Once again,I am getting an error at Line 18 on debugging.
Let me explain regarding this code result.I have worksheet 'PO' which matches A & K column with Pivot table data in B and C which is in another worksheet/s.The entire row gets highlighted with yellow in Pivot Table if C contains 'Not Approved'.
Please Login or Register to view this content.
I think this will ease.
Last edited by paradise2sr; 05-26-2019 at 04:36 AM.
Hi !
Never use WorksheetFunction when the result may be an error ‼ As using a Variant variable and just Application is enough …
Then you must check the result of the Variant variable via IsError or IsNumeric function.
Can you revised & revert the code as per Post #1.
How about this one.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Perfectly worked.But the same code of Post #1 was working last month very fine and was using since last few years but now I don't why it is creating error.
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks