Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
How to id if range is correct? | Excel Programming | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
select dynamic range with dynamic start point | Excel Programming |