define range of cells based on values that appear on other cells

Hi all,

I have a spreadsheet with dates and numbers. Every day I need to select a range of cells (D1:D??) and convert them from values based on a vlookup to values only.
I know I can use the
Range("D1:D?")=Range("D1:D?").Values (or sth like this, I have noted that down at my office)
My problem is this: the end of the range (i.e. 56 th row in D column) changes every day and I can calculate what the end of the range is and output it as a number in a cell, for instance today 23/5/2013 the range will be D1:D56. The value 56 is in a cell. Tomorrow, the value in that cell will be 57 and the range needs to be D1:D57. How can I reference this number in the cell in order to use in the range?

Hope I didn't confuse you a lot.

Cheers,
Vasilis

There are multiple ways to select the last used row in a column. One way is like this:

Please Login or Register  to view this content.

where dlastrow is an arbitrarily named variable.

You would use that variable in your range function. Example:

Please Login or Register  to view this content.