Convert Excel function into VBA code

**frnzy** · 10-02-2019, 02:44 AM

Hello everyone,
I am new to this forum ..
I am having excel formula which is taking alot of time to load that sheet...
So I now want to convert that formula and function in VBA code... As i am new to VBA coding,... Please Help me to solve my query
Below is the formula:-
=IF(ISERROR(INDEX($A$1:$C$1000,SMALL(IF($A$1:$A$1000=$R$2,ROW($A$1:$A$1000)),ROW(1:1)),3)),"",INDEX($A$1:$C$1000,SMALL(IF($A$1:$A$1000=$R$2,ROW($A$1:$A$1000)),ROW(1:1)),3))

Please Help!
Thank You in Advance...

**menem** · 10-02-2019, 03:13 AM

(Sorry about my English)

Could you please chang your formula to

=IFError(INDEX($A$1:$C$1000,SMALL(IF($A$1:$A$1000=$R$2,ROW($A$1:$A$1000)),ROW(1:1)),3),"")

This may reduce calculation time by half.

Regards.

**davsth** · 10-02-2019, 03:41 AM

It snot clear what you want as a function. Vba functions will run more slowly than formulas on a sheet.
If results ae static you can have the formula, calculate and then paste as values so it no longer needs to be calculated. You could do a keystrock macro to reinsert the formual if they need to be updated

https://trumpexcel.com/suffering-fro...-spreadsheets/

Convert Excel function into VBA code

LinkBack

Thread Tools

Rate This Thread

Display

Convert Excel function into VBA code

Re: Convert Excel function into VBA code

Re: Convert Excel function into VBA code

Thread Information

Users Browsing this Thread

Similar Threads

Convert Substitute Function in Excel to VBA code

Convert Excel Code to Access Code

VBA code to convert excel file to .txt

Need help to convert windows excel vba code to run on mac osx

[SOLVED] Convert nested if function to vba code

[SOLVED] Convert a fixed function (hard code row number) with embedded functions to last Row Functi

[SOLVED] how to convert the vlookup function to vba code

Bookmarks

Bookmarks

Posting Permissions