Correct front end of dynamic range
Could someone suggest an change in two variables
Private Sub CommandButton1_Click()
x = Range("AA1").Value
x2 = Range("AA2").Value
'Highlight_Duplicates (Sheets("Sheet1").Range("C2:V" & x))
Highlight_Duplicates (Sheets("Sheet1").Range("C" & x2:"V" & x))
End Sub
I need a front end solution for x2
Or another solution
x by itself works great for only one dimension.
With Thanks
|