Indirect Select
 

Hi Guys:

Excel - VBA - Macros
I have a chart laid out monthly, with 3 columns per day. I would like to
select about 400 consecutive cells in one of the three columns of a
specified day. My thought was to use a type of indirect addressing and do a
lookup table with the days of the month followed by the set of cells to
select for that day. I would use this selection to copy then sort to prepare
a report.

Any suggestions.

Craig

Indirect Select
 

Craig,

Try recording a macro that uses autofilters for the day and copies the
visible cells of the column of interest.

HTH,
Bernie
MS Excel MVP


"C Brandt" wrote in message
...
Hi Guys:

Excel - VBA - Macros
I have a chart laid out monthly, with 3 columns per day. I would like to
select about 400 consecutive cells in one of the three columns of a
specified day. My thought was to use a type of indirect addressing and do
a
lookup table with the days of the month followed by the set of cells to
select for that day. I would use this selection to copy then sort to
prepare
a report.

Any suggestions.

Craig