How do I select only the highlighted cells in my workbook?

P

puternoob

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?
 
S

Sheeloo

I don't think this can be done using formulae or Menu options. You can do
this using VBA...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How do I convert shading to highlighting for specific colors 8
Place picture in Excel cell 0
Shading on highlighted range of cells 0
Add value of (1) to a selected cell or cells 2
how do I set the arrow keys to move only the highlight not the ta 1
Excel does not accept text format! 0

Top