Hello folks,
a quick one
in my array I am listing ranges.
so far i have come up with this but it does look verbose.
is there an eaiser way to make the ranges in an array?Sub Array_Tasks() Dim x: x = "7:" Dim y: y = 50 oArray = Array("K" & x & "K" & y, "L" & x & "L" & y) ' which would be "K7:K50" "L7:L50" End Sub