Multiplication based on CSV string
Hello,
I want to make a function in VBA that does the following for me.
The data passed to the function is CSV data in the form "1,3,4" and a Range
of cells from a sheet. The result that has to be given back is the
multiplication of cell number 1, 3, 4 (as the CSV data indicates).
I have two questions for you:
- First is there a standard function that does this?? Or is there something
that is similar?? (I can manipulate the CSV format to whatever I want)
- Second if not then is there a method to process a CSV string as desired?
(standard built in)
If both are answered with no I guess I will need to make a CSV processing
function myself.
The CSV data comes from a text file that is automatically read by another
function.
Anybody?
Kind regards, Darius Blaszijk
|