VBA array question - column headings?

[TheWennerWoman]

Let's say I have three columns of data which I am pushing into an array.

If someone decides to insert a column after column A, say, then my data isn't what I want (arrA(a, 1) is fine but arrA(a, 2) actually refers to arrA(a, 3) and arrA(a, 3) actually refers to arrA(a, 4).

Can I substitute the numeric element with a variable?

So, let's assume column A of my source data is called "Surgery ID".

Could I assign a value to a variable based on a search for that value in column header?

In English, I'd say "search column headers for the value "Surgery ID" and assign it to a variable "a" which I would then reference in (arrA(a, a)"?

 

[TheWennerWoman]

Thank you both so much, very much appreciated

 

[Peter_SSs]

You're welcome. Hope we were able to help.