ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I select only the highlighted cells in my workbook? (https://www.excelbanter.com/excel-discussion-misc-queries/203179-how-do-i-select-only-highlighted-cells-my-workbook.html)

puternoob

How do I select only the highlighted cells in my workbook?
 
I have a big workbook with alot of data in it. I have highlighted a number
of cells that I would like to move to another workbook. Aside from going
through and selecting each cell one-by-one, is there a way to select all of
teh cells that I highlighted of a particular color?

Sheeloo[_2_]

How do I select only the highlighted cells in my workbook?
 
I don't think this can be done using formulae or Menu options. You can do
this using VBA...

"puternoob" wrote:

I have a big workbook with alot of data in it. I have highlighted a number
of cells that I would like to move to another workbook. Aside from going
through and selecting each cell one-by-one, is there a way to select all of
teh cells that I highlighted of a particular color?



All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com