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

Correct front end of dynamic range
 

I thing that if you would define your objective a little better, someone
could easily give you an answer. The code you postes is ambiguous.

"smandula" wrote:

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

Correct front end of dynamic range
 

On Dec 13, 4:52*pm, JLGWhiz wrote:
I thing that if you would define your objective a little better, someone
could easily give you an answer. *The code you postes is ambiguous.

"smandula" wrote:
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


Sorry, A more detailed explanation:

I am trying to designate a range from AA1 which would be the end
range, as
'Highlight_Duplicates (Sheets("Sheet1").Range("C2:V" & x)) which
works for x

How to also change the start range "C2" with a variable AA2? for x2
I tried
Highlight_Duplicates (Sheets("Sheet1").Range("C" & x2:"V" & x))
This doen't work

It is the front end of C2 that I am looking for a solution.

I hope this explanation helps

Correct front end of dynamic range
 

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

Correct front end of dynamic range
 

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