Tom,
Thanks for replying. I have very limited programming experience (in an
language) and
VB is the language that I'm least familiar with. Can yo
help clarify what you've written for a beginner?
I recorded the macro as you instructed. Then I opend the
VB editor
Here's what the sub looks like:
Sub SortSpecies()
'
' SortSpecies Macro
' Macro recorded 12/23/2005 by T-Dog
'
'
Range("F2:FD2").Select
Selection.Sort Key1:=Range("F2"), Order1:=xlDescending
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
_
DataOption1:=xlSortNormal
End Sub
How do I get it to do this for all rows that follow? Sorry if this i
really basic (pun intended :D) but I'm a novice!
Cheers,
Jef
--
guillemo
-----------------------------------------------------------------------
guillemot's Profile:
http://www.excelforum.com/member.php...fo&userid=2983
View this thread:
http://www.excelforum.com/showthread.php?threadid=49574