In Colorize the user selected range needs to have its last row identified:
lastrow = rngToColor.Rows.count
This presents a issue if the user selects A:A
Also, if a user selects a non-contiguous range, it should be checked as such, otherwise lastRow will be defined as the last row in the leftmost selection of the range. Actually, we should always check that #57
In
Colorizethe user selected range needs to have its last row identified:This presents a issue if the user selects
A:AAlso, if a user selects a non-contiguous range, it should be checked as such, otherwise
lastRowwill be defined as the last row in the leftmost selection of the range. Actually, we should always check that #57