Dear experts I'm trying to set a range but i get an error 91 object variable or with block not set, on the last line of my function. can someone tell me why this is
I thank you!
dim rng1 as range
x = .Cells(Rows.Count, "A").End(xlUp).Row
rng1 = .Range("A2:B" & x)