Error while executing macro

[RavindraK]

Hi Excel Gurus,
I have macro scripts , which ..
1. Stuck at line of DIS_IMO

Please Login or Register  to view this content.

(findings- it is not working when all IMOs are blanks)

2. And, in case of 45G1 [in (1) EAL_as it is], it is converting 45 into (1) EAL_List
File enclosed for your reference
Seeking Excel Gurus help to rectifying errors


K Ravindra

[Keebellah]

You have to find out why j = 0
If this is the only problem, just add a check before With Sheets("IMO MISMATCH")
to skip this section if j=0

[Keebellah]

I would do it like this:

Please Login or Register  to view this content.

[RavindraK]

Hi Keebellah,

I have checked 1st error is eliminated , thanks for your intervention, however, 2nd error is still continuing..

2. And, in case of 45G1 [in (1) EAL_as it is], it is converting 45 into (1) EAL_List instead of 45G1

Please help to rectify the said error

K Ravindra

[Keebellah]

And where do expect me to find that line of code?
YOU are the one that knows where the data comes from, I'm sorry, this is not a VBA error as such but for you it is a result error.
My suggestion is step through the code line byline and see where it is happening.
Do not expect me to do that for you,
Then tell me which part of the macro code handles this, if only this value is incorrect then it must be because of the input data and that is not a VB issue.

[RavindraK]

Hi
It is part of
Sub EAL_T2C()
And at line

Please Login or Register  to view this content.

It is converting (text to column) ISO code from (1) EAL_as it is to (1) EAL_List
Apart from specific ISO which is alphanumeric value, all other ISOs (with numeric values ) are converting (text to column)
values successfully.
Can you please look into the same.

K Ravindra

[Keebellah]

And what do you expect me to do for you? Troubleshoot ALL YOUR CODE?
I think you can do it yourself, like I said it the data input that causes the problem.
You seem to know the exact row and sting it happens, so that part which is not numeric is the problem.
I am NOT going to look for that string so if you have concise infromation, then maybe I can help, but you can also write your own macro to check if it is numeric or not, if it is not numeric add code to take care of that.

[RavindraK]

Hi Excel Gurus,

I have macro naming EAL_T2Cwhich is converting text files from (1) EAL_as it is to (1) EAL_List
And at line, it is defined as 4 characters from 26 characters are to be considered as ISO code (in each available line)
i.e.

Please Login or Register  to view this content.

It is converting (text to column) ISO code from (1) EAL_as it is to (1) EAL_List
Apart from specific ISO which is alphanumeric value, all other ISOs (with numeric values ) are converting (text to column)
values successfully.
Into (1) EAL_as it is ISO code may be numeric (e.g. 4510 etc.) or alphanumeric (e.g. 45G1 etc.)
I have checked all twice but unable to fix it.

Can anybody please help me to fix the issue.

K Ravindra

[Keebellah]

In which row is it happening?
What is the string?

[RavindraK]

Please Ref. attached files (Image and excel file, those are self-explanatory)

[Keebellah]

I'll see what I can find and do

[Keebellah]

well I think if you had concentrated on it you would have found it.
Your code

Please Login or Register  to view this content.

Corrected (I hope )

Please Login or Register  to view this content.

VAL ONLY extracts numbers

[RavindraK]

Thanks Keebellah,
Seems correct , I'ill check and revert with findings..

[Keebellah]

And, have you verified?

[RavindraK]

Keebellah,
The said error has been rectified , however, the new error taking place..
In case of IMO mismatch , list is populated / appearing in Index sheet (starts from B3) instead of IMO Mismatch worksheet (to be started from B3)

[Keebellah]

My guess is that your code does not correctly reference worksheets and cells.
Take it line by line while executing.

[Keebellah]

Nothing in B3 here.
Your explanation does not tell ME anything so ...
Need help make sure you explain it exactly and what to check for what you have what you expect and what the macro is supposed to do.
YOU are the one that wrote (I hope for you) the macro and knows what it should do, do not expect anyone else to try and guess what you would like to happen.
Communication, that is really important