range select a value in a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to a formula thru out a worksheet 2
Conditional format order priority 2
Change the Color of a Cell through a Macro 4
Blank cells , & cells with 0 in them 1
relative cell reference in custom validation 2
Excel VBA 1
VBA help to copy variable range 7
Averaging Array Formula 5

Back
Top