Excel Insert Row Shortcut : These shortcuts will help you insert single and multiple rows quickly.Excel Shortcut Keys for Merge and Center : This Merge and Center shortcut helps you quickly merge and unmerge cells.How to use wildcards in excel : Count cells matching phrases using ...
FunctionSubtractRanges(RangeA, RangeB)AsRange'' Returns a range of cells that are part of RangeA, but not part of RangeB'' This function handles big RangeA pretty well (took less than a minute' on my computer with RangeA = ActiveSheet.Cells)'DimCommonAreaAsRangeDimResultAsRangeSetCommonAr...
'Set multipleRange = Union(r1, r2) On Error Resume Next If Selection.Cells.Count > 1 And Selection.Cells.Count < limit Then On Error Resume Next Application.StatusBar = _ " D: " & Format(DIFF(r1, r2), frmt) & _ " U: " & Format(Unique(r1), frmt) & _ " 2X: " & Format...