Ranges

  • Thread starter Thread starter Bill Leroy
  • Start date Start date
B

Bill Leroy

Is it possible to define a range to be used in a formula for which the number
of cells contained in that range depend on a variable e.g. a date in another
cell
 
Yes, you can use the OFFSET function, with the width or height parameter of
the resulting array being determined by a calculation.
 
It works great
--
Thks
Bill Leroy


David Biddulph said:
Yes, you can use the OFFSET function, with the width or height parameter of
the resulting array being determined by a calculation.
Click to expand...
 
You must log in or register to reply here.

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

Excel VBA 1
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Formula ... Minus Holidays? 1
VBA set thick borders around non empty cells in range 0
Using the contents of a ADDRESS formula as the cell range in a for 3
I need help with this program written in Visual Basic for Excel 2007. 4
Shut off / disable a constant? 2

Back
Top