In need of expert advice

[CADman1969]

Hello everyone,

I created a Lambda function that works perfectly for me,

Please Login or Register  to view this content.

I assigned this function in name manager called "Conversion".

if I manually enter the following in a cell H16 for instance, the formula works perfectly and I get the result I need.
(H16 is part of a table, so that is why you see column references in the code)
(Also, ConversionTable is just another table created to fine the result I need)

Please Login or Register  to view this content.

I am now trying to enter this exact same code, in cell H17, using the following VBA code,

Please Login or Register  to view this content.

The problem I am having is with the '(Conversion(G16,F16)' portion. the G16 and F16 need to represent the current row I am working on, in this case 17. But they stay consistent at G16 and F16.

I tried changing the G16 to "range("G" & selection.row).value)' and did the same thing for the F16

So my VBA Code looks like this,

Please Login or Register  to view this content.

how ever I instantly get a compile error, expected end of statement and the "G" in 'range("G" & selection.row).value' is highlighted.

I hope all this makes sense, I tried to be as detail as I could.
Does anyone know how to insert a lambda function using VBA where the variable(s) needed are dynamic and are base on the current row you are working on.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to consider amending your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Guideline #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

[CADman1969]

I was able to finally solve it using the following;

Please Login or Register  to view this content.