Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count based on string in cell | Excel Worksheet Functions | |||
Conditional Format based on sub-string | Excel Discussion (Misc queries) | |||
split string based on a SET of words | Excel Discussion (Misc queries) | |||
Open Books with VBA based on certain string | Excel Discussion (Misc queries) | |||
Extract String based on condition | Excel Discussion (Misc queries) |