I am working on the below code. My goal is to apply a light background color to 6 specific columns.
I want this background color to only occur in these columns to the last row. I don't want it to extend past the last row
When I apply this code I get an error if I reference the "lrow". If I run this by just the whole columns reference it works but the coloring will go way below my last row.
Only other issue is a loop which is a bit nutty for a 1000 rows by 6 columns.
Thank you
I want this background color to only occur in these columns to the last row. I don't want it to extend past the last row
When I apply this code I get an error if I reference the "lrow". If I run this by just the whole columns reference it works but the coloring will go way below my last row.
Only other issue is a loop which is a bit nutty for a 1000 rows by 6 columns.
VBA Code:
Range("AK:AP" & lrow)).Interior.Color = RGB(255, 228, 196)
Thank you