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.

I would suggest perhaps creating that column into a named range. then i
your code you can refer to it as range("time").value which is the valu
of the the range of column. if the column increase or decrease it wil
always refer to the range that you require

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=55598

funkymonkUK wrote:
I would suggest perhaps creating that column into a named range. then in
your code you can refer to it as range("time").value which is the value
of the the range of column. if the column increase or decrease it will
always refer to the range that you require.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=555986


Thanks for the help...and such a quick response!