pulling data from excel workbook

[david shapiro]

I've created an excel workbook with several worksheets.
In each worksheet, I've highlighted a number of the cells containing key
statistics in red.

Is there any easy one-step way that I can pull all of the cells
highlighted in red out of all of the worksheets in the workbook and put
them all in one separate worksheet? Or is there a macro you might
suggest?

Unfortunately, the red cells are not in any systematic order in the
worksheets (all the worksheets are rather different). Pulling the red
cells out would just have to be on the basis of color.

Thank you.

Dave


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Paul Clement]

On Mon, 09 Aug 2004 12:48:24 -0700, david shapiro <da***********@hotmail.com> wrote:

¤ I've created an excel workbook with several worksheets.
¤ In each worksheet, I've highlighted a number of the cells containing key
¤ statistics in red.
¤
¤ Is there any easy one-step way that I can pull all of the cells
¤ highlighted in red out of all of the worksheets in the workbook and put
¤ them all in one separate worksheet? Or is there a macro you might
¤ suggest?
¤
¤ Unfortunately, the red cells are not in any systematic order in the
¤ worksheets (all the worksheets are rather different). Pulling the red
¤ cells out would just have to be on the basis of color.
¤

You may want to re-post this question to microsoft.public.excel.programming.

I'm not sure how you are "hi-lighting" the cells (changing background color?) but checking whatever
attribute that defines the cell as hi-lighted would be the only method I can think of.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)