byronwall / bUTL

Excel add-in with helpers for charting, formatting, and general pain points
http://byroni.us/bUTL
MIT License
16 stars 3 forks source link

Sub Colorize lastRow #56

Open RaymondWise opened 8 years ago

RaymondWise commented 8 years ago

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 https://github.com/byronwall/bUTL/issues/57