how to concatenate in rc reference styles in excel vba macros

Dear Friends,

I am performing a linear interpolation for my class project. I have created a function to perform dynamic calculation with help of last column count(lrt). So, I have retrieved the value for last column(ltr) and tried to concatenate with R1C1 reference generated through macro recording. But it doesn’t work.

Please Login or Register  to view this content.

Could you please suggest some idea on how perform workaround for this issue.

Please find below the following code:

Please Login or Register  to view this content.

Sorry Friend.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

When you are calculating a formula to put in a cell, it is easier to assign the formula to a string and print it to the immediate window. If it's a valid formula, you can copy and paste it into a cell and see it work. If not, fix it:

Please Login or Register  to view this content.

Another way to do simple variable substitution:

Please Login or Register  to view this content.

Then you can put it in the cell(s):

Please Login or Register  to view this content.

You're welcome.