W
WBTKbeezy
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 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