Thread: VBA arrays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hokiebird hokiebird is offline
external usenet poster
 
Posts: 1
Default VBA arrays


Hello all, first time post

I'm trying to access only part of an array.

Suppose A in an array of integers with 10 cells...
Dim A(1 to 10) as integer

...some code to fill up A

Now lets say I want to call a subroutine with only cells 4-8, how do
do this?

In other codes we can do something like this...
Call SomeSub(A(4:8))
but i can't for the life of me figure out how to do this in VBA...
HELP

--
hokiebir
-----------------------------------------------------------------------
hokiebird's Profile: http://www.excelforum.com/member.php...fo&userid=1630
View this thread: http://www.excelforum.com/showthread.php?threadid=27699