Selecting multiple row problem

**welchs101** · 12-23-2008, 07:01 AM

Hi, I am trying to select multiple rows so that i can sort. The code i have

Set userrange1 = Workbooks(File_Name).Worksheets(Sht_name).Range("2:10").Select

the above only works if "Sht_name" is the active sheet. If "Sht_name" is not the active sheet then the above code does not work. Any suggestions?

**welchs101** · 12-23-2008, 07:37 AM

Hi,

I thought i had fixed the problem with the following code but it does not work for some reason.

Workbooks(File_Name).Worksheets(Sht_name).Range("2:10").Sort key1:=Range("G1"), order1:=xlAscending, Header:=xlYes

**welchs101** · 12-23-2008, 07:56 AM

i guess i needed to also specify the full path after the "key1"

Workbooks("working_file.xlsm").Worksheets("Sheet7").Range("2:20").Sort _
        key1:=Workbooks("working_file.xlsm").Worksheets("Sheet7").Range("G4"), order1:=xlAscending, Header:=xlNo

this seems to work. My question now is can the "Range("G4")" entry be any value like G1, G2 or just G

Selecting multiple row problem

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Selecting multiple row problem

Still have problem but wanted something like this

this works

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions