Hello:

I am looking for a way to have a macro that will automatically select a
range by the cells in the ranges background color. I have an area that is a
set width, (cells H-K) but the length can vary depending on other information
in the sheet. I have conditional formatting set to automatically color the
cells blue how it is supposed to, but would like a macro that will
automatically select the cells that are blue. Any ideas?

Thanks

You can try my EasyFilter add-in for one column
http://www.rondebruin.nl/easyfilter.htm
If you want to copy/hide or delete the rows



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"WBTKbeezy" wrote in message ...
Hello:

I am looking for a way to have a macro that will automatically select a
range by the cells in the ranges background color. I have an area that is a
set width, (cells H-K) but the length can vary depending on other information
in the sheet. I have conditional formatting set to automatically color the
cells blue how it is supposed to, but would like a macro that will
automatically select the cells that are blue. Any ideas?

Thanks

No, I am not looking for any kind of adding/deleting or copying, I just need
a simple select (Once selected, I need to upload data into a different
add-in)...

There are IF formulas in the cells that yeild a blank (="") if false (which
is also when there is NO blue - so I would not want it selected...)

"Ron de Bruin" wrote:

You can try my EasyFilter add-in for one column
http://www.rondebruin.nl/easyfilter.htm
If you want to copy/hide or delete the rows



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"WBTKbeezy" wrote in message ...
Hello:

I am looking for a way to have a macro that will automatically select a
range by the cells in the ranges background color. I have an area that is a
set width, (cells H-K) but the length can vary depending on other information
in the sheet. I have conditional formatting set to automatically color the
cells blue how it is supposed to, but would like a macro that will
automatically select the cells that are blue. Any ideas?

Thanks

I figured out a different way for this, I have created a dynamic named range,
so in a macro I can select that range, but the range will change sizes.


"WBTKbeezy" wrote:

No, I am not looking for any kind of adding/deleting or copying, I just need
a simple select (Once selected, I need to upload data into a different
add-in)...

There are IF formulas in the cells that yeild a blank (="") if false (which
is also when there is NO blue - so I would not want it selected...)

"Ron de Bruin" wrote:

You can try my EasyFilter add-in for one column
http://www.rondebruin.nl/easyfilter.htm
If you want to copy/hide or delete the rows



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"WBTKbeezy" wrote in message ...
Hello:

I am looking for a way to have a macro that will automatically select a
range by the cells in the ranges background color. I have an area that is a
set width, (cells H-K) but the length can vary depending on other information
in the sheet. I have conditional formatting set to automatically color the
cells blue how it is supposed to, but would like a macro that will
automatically select the cells that are blue. Any ideas?

Thanks