View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
devo devo is offline
external usenet poster
 
Posts: 6
Default 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