Using a MACRO to sort data

[BAM718]

Is there a way to use a Macro in an Excel Workbook that would allow me to
sort multiple sets of data on multiple sheets at one time?

P.S. I have never created a Macro before.

 

[Don Guillett]

something like this?

Sub sortall()
For Each sh In Worksheets
With sh
..Range("B3:B4").Sort Key1:=.Range("B3"), Order1:=xlAscending
End With
Next sh
End Sub

 

[Mexage]

I completely agree with Don Guillett's answer, but I must say, if you haven't
ever created a macro, I highly recommend you to read
http://office.microsoft.com/training/training.aspx?AssetID=RC011506201033
(macro tutorial, about 30-50 minutes).

And also, don't put the two period (..) before Range.
Hope that helps.

Greetings from México!

 

[Don Guillett]

I didn't put .. before range......... ONLY 1 .

 

[Mexage]

well, if you didn't, it does appear that way in your original post... check
it out

:-D

 

[Don Guillett]

Before I answered, I did but it wasn't in my macro or it wouldn't have
worked..............................