Look in Column and Delete Certain Text

helpexcel

Well-known Member
Joined
Oct 21, 2009
Messages
553
forgot to change .Columns("A:A").Sort key1:=Range("A1"), order1:=xlAscending, Header:=xlYes to .Columns("A:A").Sort key1:=.Range("A1"), order1:=xlAscending, Header:=xlYes
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,099,898
Messages
5,471,371
Members
406,758
Latest member
Antsnetswprk

This Week's Hot Topics

Top