Dynamic Arrays

C

Craig

Can a dynamic array, or an array with no fixed number of
cells, be created or declared using VBA? If this is
possible, can someone please show me the syntax for
declaring one? If not, let me know that also, please.

Thank you

Craig
 
M

Marshall Barton

Craig said:
Can a dynamic array, or an array with no fixed number of
cells, be created or declared using VBA? If this is
possible, can someone please show me the syntax for
declaring one? If not, let me know that also, please.
Click to expand...


Check Help on the ReDim statement.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Public Dynamic Arrays 6
CountA and Countif and Arrays 12
MultiDimensional Array Syntax 4
Dynamic Creation of Arrays - Sorting into Bins problem 2
emptying array contents 1
is array redimmed? 5
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
ReDim not working as expected. Array expert needed. 16

Top