Sorry I could not interpret what you were after. I now see that you wanted
to use the variable for the AA2 value as the row number for Column C. Guess
I never thought of it as front end before.

"smandula" wrote:

Solution

Thanks to everyone who read this message

Private Sub CommandButton1_Click()

x = Range("AA1").Value
x2 = Range("AA2").Value

Highlight_Duplicates (Sheets("Sheet1").Range("C" & x2 & ":V" & x))

End Sub

'-------------------------------------

Just rearranged Quotes