2003/2007

fCount is a number of "Operators" in a Formula string
iCounter is the InStr() position of each operator in a Formula string

The variable which I wish to initiate is, temporariiy labeled, "Hold".

Hold = "Gap" & fCount & "Start" & "(" & iCounter & ")"

In my context, the contents of "Hold" is Gap4Start(13)

How do I Dim Gap4Start(13) in the midst of a running procedure?
i.e., Dim Gap4Start(13) as Long (So that, ? Gap4Start(13) is 13)

My goal is to be able to "address" each Gap?Start(x) and obtain the contents :

Or put differently: The character position of the start of a "Gap" in the fourth
cell reference in FormulaStr is 13

I hope that I have been clear.

TIA EagleOne