I recently came across this section of code and was wondering what these variables represent?
The code works as intended ( highlights all dates within the range Q, R, S, T &U to last row, that matches (same month) of a date in Column I.Sub Demo1() Const F = "IF(ISNUMBER(Q#:U#),IF(MONTH(Q#:U#)=MONTH(I#),ADDRESS(#,COLUMN(Q#:U#))))" Dim L&, R&, V L = UsedRange.Rows.Count Application.ScreenUpdating = False Range("I2:I" & L & ",Q2:U" & L).Interior.ColorIndex = xlNone For R = 2 To L V = Filter(Evaluate(Replace(F, "#", R)), False, False) If UBound(V) > -1 Then Range("I" & R & "," & Join(V, ",")).Interior.ColorIndex = 6 Next Application.ScreenUpdating = True End Sub
I am curious about the L&, R& designations





Reply With Quote
