Cell input into formula
 

Ok...perhaps tough to explain. I'm doing a macro in which the length of the
analyzed document changes. I'm attempting a work around in which the last
row of populated cells is input into a cell. (assume 1000 is entered into A1)

Macro will select the equation: =concatenate("b2:f",a1)

Essentially, this is the key to what I need to figure out how to do. (I'm
not very good with VB)