MrExcel Publishing
Your One Stop for Excel Tips & Solutions

setting range in macro


Posted by Barry ward on August 02, 2001 6:20 AM

I want to select a range in which the row number of the last cell is dependent on the product of another formula.... any ideas?

Barry


Posted by Barrie Davidson on August 02, 2001 9:17 AM

Can you clarify what you mean. What is the formula?

Barrie

Posted by Barry Ward on August 02, 2001 9:34 AM

I want to use the product of the following formula ... =(D3-1)*60+61 ... which in thisa case is 901 to specify that the range I want selected should be "A124:B901" .

How do I concatenate the "B" which is constant with the "901" which is dynamic?

Posted by Barrie Davidson on August 02, 2001 9:52 AM

If I understand your situation, try this:

Range("A124:B" & (Range("D3").Value - 1) * 60 + 61).Select

Hope I got it right:)
Barrie

Posted by Barry Ward on August 02, 2001 10:07 AM

Thanks you're a star..... nfm


Cheers