Hello;
I have an autofilter on more than 10 columns of data. I don't have any problems writing code to filter different scenarios. My problem is figuring out what code will filter the data and only color the "result" data up to the last row of the result?
To get by, I have a haphazard macro setup that will filter data and color a set range. I did this to test my "sort by color" and that now works. However, the data will constantly fluctuate therefore my row count will never be the same and I'm left with a lot of blank rows that are colored. Thank-you for your assistance.
I have an autofilter on more than 10 columns of data. I don't have any problems writing code to filter different scenarios. My problem is figuring out what code will filter the data and only color the "result" data up to the last row of the result?
To get by, I have a haphazard macro setup that will filter data and color a set range. I did this to test my "sort by color" and that now works. However, the data will constantly fluctuate therefore my row count will never be the same and I'm left with a lot of blank rows that are colored. Thank-you for your assistance.