I am trying to create a variable from a formula.

The formula is a max() and a min() where the row numbers change and ar
variables. e.g I go to end of column and and set a variable calle
LastRow. Then I have another varaible that is MyRow which equal
LastRow-a number which has been inpuuted by an Input box.

Is there a way you can use a variable in a formula

--
Message posted from http://www.ExcelForum.com