• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP in VBA

prsnthkrishna

New Member
Hi All,

I have 7lakhs to 8lakhs lines/rows in excel file. I have prepared an excel macro. In Module1, I used LOOKUP formula and it gives incorrect result. So, I changed it to INDEX and MATCH formula. This is consuming time. After writing this INDEX formula, I used text to column formula to get the correct result.
If I do not use Text to column, I'm getting incorrect result.

Is there any other way to get the results with less time. Can anyone help in this. The macro coding file is attached.
Let me know if any corrections to be made in the code.

Regards,
Prasanth Krishna
 

Attachments

  • SNT Report.xlsb
    356.5 KB · Views: 10
  • Deserialise File.xlsx
    184 KB · Views: 10
  • Joker Type File-New.xlsx
    10.3 KB · Views: 6
  • 5102.xlsx
    14.9 KB · Views: 6
  • NEW SNT Steps .docx
    19.1 KB · Views: 7
prsnthkrishna
Questions:
Bases Your above written text - what are the steps?
... Please, do not refer to any Word-document
What/where is/are expected results as well as from which file?
How long period is 'less time'?
 
prsnthkrishna
Yes ...
... three questions
... one reply ( and You missed that my please, sentence )

You could try to modify Yourself Your code
a) the most part of .select - selection - combinations
b) add codes
( if no need formula-calculation while running Your code )
Code:
' add in the beginning
With Application
    acm = .Calculation
    .Calculation = xlCalculationManual
End With

' add in the end
Application.Calculation = acm
 
Back
Top