Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
arrayname as variable
Hi
Could someone please explain how to do the following I wish to have a function which i can pass a string which is an array name and then be allowed to manipulate the array ie array_width or array_drop function dosomethingwitharray (arrayname as object) test1 = arrayname.ubound test2 = arrayname.lbound ' do something with array End function but i seem to be getting erros with setting and passing the arrayname |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |