writing function in VBA

[johnboy12]

Hi everyone,

I've got a function written in R that I want to convert into VBA. The function takes in 2 arguments a matrix of data and a tolerance level (scalar). I ideally would like the data input in an Excel spreadsheet - matrix and scalar and output the data to a location on another spreadsheet. This is my function in R:

Please Login or Register  to view this content.

Would really appreciate any help on this.

John

[Leith Ross]

Hello johnboy12,

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the link below...

Forum Rules

Sincerely,
Leith Ross

[johnboy12]

Thanks Leith.

John