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

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
>
>

On Dec 13, 4:52*pm, JLGWhiz <JLGW...@discussions.microsoft.com> 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

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

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
>
>
>