I have a table on an Excel sheet.
I need to select and assign to a matrix a variable range that depends on two variables: Start Dia and DiaFinal .
The first column of the table is a date field with this format:
dd/mm/aaaa;
This table has 4 additional columns, with a total of 5 columns to be selected between both dates.
In this way, the range of rows and columns between Start Dia and DiaFinal will be the object to be selected.
To have a clearer idea, we have the following example:
In the previous table, I need to select and assign to a matrix the range between DiaInicial = 23/09/2010 and DiaFinal = 29/09/2010 .
That is, the macro should read the range delimited between both dates and assign the range to an array.
How can you make this selection?