Hello, This is my first post on this forum. I have only been using vba for a couple of weeks now. My problem is this: I'm trying to declare a const variable with ...

VBA: Declare a cell range as a value for a Constant. This is a discussion on VBA: Declare a cell range as a value for a Constant within the Excel Questions forums ...

(Excel VBA) How would i declare an active workbook variable. or a workbook variable in general. I have a program flipping back and forth between 2 excel …

Declaring Constant Arrays? This is a discussion on Declaring Constant Arrays? within the Excel Questions forums, part of the Question Forums category; Hello Can I ...

Hi, I am trying to declare a public variable array in Excel VBA as follows : Public Qty(10) As String .....but when I reference the array in my Sub it returns the ...

Let us say I have array constant in a1 as follows: {1;2;3;4;5} And suppose I want to store the above in an array using VBA...so dim my_Array() as integer my_array ...