Macro Sort

[MyCuteHeart]

Hi Guyz,

Been recording a macro that sorts different columns at a time but after recording it and tried the macro, it always give me an error and does not do the sorthing. See below part of the code where it gives an error. Please help. Thanks a lot.

Text in bold is the one making the error.

Range("D2:D31").Select
ActiveWorkbook.Worksheets("jag2_ptr_thermal prt rev10 03_0").Sort.SortFields. _
Clear
ActiveWorkbook.Worksheets("jag2_ptr_thermal prt rev10 03_0").Sort.SortFields. _
Add Key:=Range("D2:D31"), SortOn:=xlSortOnValues, Order:=xlAscending, _
DataOption:=xlSortNormal

 

[jproffer]

It should work without it. You're setting new sortfields in the next line.

 

[MyCuteHeart]

Hi Jproffer,

The macro was recorded that way. I tried erasing this line, then the next line was the next error.

 

[Smitty]

Welcome to the Board!

Is the worksheet protected?

What error do you get?

 

[MyCuteHeart]

Hi Smith,

The worksheet is not protected. And I get an error like this.

Run-time error '1004':
Application-defined or object-defined error

then when I clik debug, it points to the code in bold letters above.
Please help. Thanks

 

[jproffer]

I ran it on a sheet with that name and it ran through....it didn't DO anything, but it didn't error. Are you sure the sheet name is correct?...Object error sounds like it's something like that.

 

[MyCuteHeart]

I ran it on a sheet with that name and it ran through....it didn't DO anything, but it didn't error. Are you sure the sheet name is correct?...Object error sounds like it's something like that.

Hi jproffer,

How to know if the sheet has a name as that. Sorry I'm new in macro.
What I do is, I record the macro in an excel file and then I export the macro and I import the said macro to another excel file and try to run it. Then it gives me an error. What should I do? Thanks.

 

[jproffer]

The name on the tab should match the code exactly or it won't run.

Do you mean you record it in one workbook, then move it to a second workbook?

 

[MyCuteHeart]

The name on the tab should match the code exactly or it won't run.

Do you mean you record it in one workbook, then move it to a second workbook?

Hi Jproffer,

Yah. I got it now. Thank you very much Sir. Hope to help me again if I need a help. Thanks again.