Hi,

I have a macro in my worksheet that uses data validation in column A. I was able to fill the data validation throughout the entire A:A range. Another feature of my macro is to color code the entire row based on the data validation value selected in column A. However, i was only able to fill down this color coding to the edge of data. Since the amount of rows in the data range will never be consistent, i want this color coding to be filled down, with the data validation, throughout the entire A:A range.

My code is below. Your help is appreciated!

Please Login or Register  to view this content.