I have to modify an excel template that is currently using the columns
and rows of the spreadsheet to make calculations. The problems is
people decide to change the columns every so often. I am new to vba and
I am trying to figure out the best method for me to use the header name
for the column (for example "Time") in my calculations. So if "Time"
was originally at (1,19) then it changed to (1,22) excel would still
look for the column header and base it calculations off the data in the
column "Time". I would paste the code that I have to modify but its
about 250 pages.