Indirect Select

C

C Brandt

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
 
B

Bernie Deitrick

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
 
Top