SORT - need to restrict sort macro to active sheet that has

[itr674]

Have sheets that are suffixed with DTM. I want to run the sort routine on active DTM sheet only. If DTM is not on the end of the sheet name (1) don't run the routine and (2) would like a message box to come up and tell user they can't run rountine on that paricular active sheet.

Sample sheet name Carl - DTM.
This message was edited by em on 2002-10-18 14:12

 

[stevebausch]

If instr(1, activesheet.name,"DTM",vbTextCompare)> 0 then
'This is a DTM page


or


if instrrev(ActiveSheet.Name,"DTM",,vbTextCompare)= Len(ActiveSheet.Name)-2 then
'This is a DTM page
This message was edited by stevebausch on 2002-09-21 19:42