dim condensedRange as Range Set condensedRange = WS.Range("A1", WS.Range("A1").End(xlDown).End(xlDown).End(xlUp)) condensedRange .AdvancedFilter Action:=xlFilterInPlace, Unique:=True
|how to read all the sheets in excel||12||42|
|After updating data my Excel graphs are showing too many dates||8||32|
|VBA Array, write each column's start position into an array||17||35|
|Excel VBA When using VLookup||6||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!