Excel function result using vba

**pnnaik** · 06-19-2015, 08:24 AM

Dear All,

I have excel sheet to fetch data from text file. It is mixed of excel function and VBA code.For sorting copy and transfer data I used VBA recording. But take a lot time to run. So I wish to learn VBA and want to write entire code in VBA. Towards first step

To know how excel function work in VBA I have created small excel file.

I have text data in column A and to get required information excel sheet function in column B.
In column A I have data and in column B formula.
Data in column A are not fixed number, it varies. Kindly guide me to write VBA code.
Regards,

PN

**PCI** · 06-19-2015, 09:38 AM

See here

Please Login or Register  to view this content.

**pnnaik** · 06-23-2015, 08:34 AM

Dear PCI,

Thank you for your kind reply.
This would help me in creating my excel sheet.
I would like to know is it wise to use excel function in worksheet or in VBA to faster the process.

Regards,
PN

**PCI** · 06-23-2015, 09:58 AM

A geat asset of macros is that you can fire them only when you want, and therefore it does not slow down calculation.
Of course this is not free because for maintenance purpose "excel function" are really easier to use.
Time, Cost, Quality .. it is difficult to be the best for all of them at the same time.