C
camron107
I have formulas calculating values to produce cell references such as J10, L15 etc
the formulas are similar to ="I"&TEXT(Q4, "d")
I am creating a macro where I want to select the cells calculated from my formulas...
instead of using range("J10:K10").select
i want the range to use the specific cell reference calculated in my formula...
because the range i want to select changes every time a new record is added.
is there a way to do this?
any help is much appreciated. thanks
the formulas are similar to ="I"&TEXT(Q4, "d")
I am creating a macro where I want to select the cells calculated from my formulas...
instead of using range("J10:K10").select
i want the range to use the specific cell reference calculated in my formula...
because the range i want to select changes every time a new record is added.
is there a way to do this?
any help is much appreciated. thanks