Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

Could some one help me to translate this formula to VBA code?

My objective is to calculate the value inside the macro and putting the

results directly in the right columns.

Let's give an example:

In the columns "H" I have the following formula:

H11 =

(INDEX(CUSTOCAD,,MATCH((IF(ISERROR(FIND(".",$E11)),$E11,LEFT($E11,LEN($E11)-

2))),CAPDESPE,0))) : Formula 1

In the columns "I" I have the following formula:

I11 = IF($F11="USD",$G11/TXCAMBIO, $G11) : Formula 2

In the columns "J" I have the following formula:

J11 = ($D11)*(100+$H11+$I11)/100 : Formula 3

CUSTOCAD, CAPDESPE and TXCAMBIO are range name.

I would like that the VBA code make the following:

Value1 = Formula 1

Cells(H11) = value1

Value2 = Formula 2

Cells(I11) = value2

Value3 = Formula 3

Cells(J11) = value3

How can I convert the Formula1, Formula2 and Formula3 in VBA code?

Didn't find what you were looking for?
Find more on Formula using range name in VBA code
Or get search suggestion and latest updates.

Related Topics:

- VBA Code for pasting a set of formulas down a data range
- VBA variable range in a formula
- Using VBA to name Ranges
- highlight a range using a named range
- VBA code to add values in two cells which have formulas
- VBA code to delete people from a list using the name in a textbox
- VBA Excel Coding for dynamically changing function range
- writing vba code to generate vba code
- writing vba code to generate vba code
- Insert Rows, based on data in range, using VBA
- Using a Defined Variable Range in a VBA SumIf
- cells containing formula that refer to user-defined VBA function
- Getting a formula to copy from inside VBA
- VBA or array formula?
- Copy down formula with vba
- formula help but not vba please
- VBA Formula prob
- Error when using variable to name a range
- using macro to create dynamic named ranges
- Convert code from excel 2000 vba to excel 2003 vba
- Placing VBA Code "Live" Into Another WkBook Via VBA
- How to obtain minimum in a range with VBA
- VBA and Arrays/Ranges
- Reference range row and column in VBA
- Reference range row and column in VBA