Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba dynamic
hi experts!
i ve this macro but i want to make it dynamic how can i do it? Sub Macro1() €˜ €˜ Macro1 Macro €˜ €˜finalrow = Cells(Rows.Count, 1).End(xlUp).Value ActiveWorkbook.Worksheets(€œSheet2€³).Sort.SortF ields.Clear ActiveWorkbook.Worksheets(€œSheet2€³).Sort.SortF ields.Add Key:=ActiveCell, _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal With ActiveWorkbook.Worksheets(€œSheet2€³).Sort ..SetRange ActiveCell.Range(€œA1:A14€³) ..Header = xlNo ..MatchCase = False ..Orientation = xlTopToBottom ..SortMethod = xlPinYin ..Apply End With End Sub i used this code .SetRange ActiveCell.Range(Selection, Selection.End(xlDown)) instead of .SetRange ActiveCell.Range(€œA1:A14€³) but was not able to make my macro dynamic how can i make my macro dynamic? make macro dynamic help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba dynamic
Hi
Try this: SetRange Range(selection,Range(selection).end(xldown)) Regards, Per On 12 Feb., 01:32, danial mansoor wrote: hi experts! i ve this macro but i want to make it dynamic how can i do it? Sub Macro1() €˜ €˜ Macro1 Macro €˜ €˜finalrow = Cells(Rows.Count, 1).End(xlUp).Value ActiveWorkbook.Worksheets(€œSheet2€³).Sort.SortF ields.Clear ActiveWorkbook.Worksheets(€œSheet2€³).Sort.SortF ields.Add Key:=ActiveCell, _ SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal With ActiveWorkbook.Worksheets(€œSheet2€³).Sort .SetRange ActiveCell.Range(€œA1:A14€³) .Header = xlNo .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With End Sub i used this code .SetRange ActiveCell.Range(Selection, Selection.End(xlDown)) instead of .SetRange ActiveCell.Range(€œA1:A14€³) but was not able to make my macro dynamic how can i make my macro dynamic? make macro dynamic help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic pivot table linked to dynamic excel spreadsheets | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | 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 |