header=xlno

Hi, I am using this VBA script to get some sorting done. But my cells reference formulas on other sheets that do not trigger it as the cell changing - hope that makes sense. Can I nest and Else if to look at the other sheets to trigger the changes? Working... Private Sub...

Not sure why this is not removing the duplicates in Column C. Any help would be appreciated. Sheets("Sheet7").Range("C1:C100").RemoveDuplicates Columns:=3, Header:=xlNo

Hi I have the below sort which just uses I4:I28 etc as the asending sort what would below look like if I wanted to firstly sort F4:F28 in the order "Active then Inactive then extra" and then sort I4:I28 ascending for below rows Sub TestSort() ActiveSheet.Unprotect Range("4:28").Sort...

Hi I have the below macro that that sorts for example ranges A5:CD22 based on B5:B22 sort selection. How would it look if instead of selecting the specific ranges as above but rather I wanted to sort entire rows 5:22 based on B5:B22 sort selection? Any help would be great. Thanks Stephen Sub...

I am on Excel 2010 version. How do you sort on 2 columns? The first sort will be by Column B, Ascending, then by Column G, Descending. Below is the code I have. Range("A3").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Sort...