Need to add a few more lines in the code.

[RAJESH1960]

Hello JohnnyL

With the help of your code, I have successfully created this new app where the range is different. There is no 2A or Tally rows in this app. It has to match the GSTIN of all rows. It works perfectly. In this app, with your edited code, I need to continue the code with a few more lines of code and also edit the message box. After the code is run, I want the code to

• Look for errors in GSTIN verification sheet Column K, and if found I want the rows with errors to be colored Yellow in the Purchases Sheet. Message box to display “GSTIN not matching. Check & Edit.”
• If errors not found then the msg box to display “All GSTIN Numbers Matched.”
• When I run the code, the web site is in full view while running. If possible, avoid or run the web site in the background and hidden from display with one of those lines you use to avoid opening the hidden sheets like Application.DisplayAlerts…
• When the code is making a copy of the Purchases sheet, avoid copying the code button in the copied sheet (GSTIN verification sheet).
• This data doesn’t have green color but as your code runs and works for the green cells, I have colored all the rows as green. I was not able to edit that part. If it is easy to change the green part, please change it otherwise it is easy to color the rows in green and then run the code. As you wish.Test get GSTIN of Purchases Ledgers.xlsm

 

[RAJESH1960]

Sleep man. Will discuss tonite.

 

[RAJESH1960]

No, it actually pertains to another code you were working with. Where if only one cell was detected, it wouldn't save as an array, it would only save as a variable.

I don't know of the other code, it is the same case, in this code too. When there is only one cell which has one single incorrect GSTIN, it is generating error at

            For ArrayRow = 1 To UBound(IncorrectGSTIN_NumbersArray, 1)                      '       Loop through rows of IncorrectGSTIN_NumbersArray

Don't expect me to correct that ok. It is beyond my standards to correct it.