Calculate Business Working Days between two dates (Excluding Saturdays and Sundays) Date/Time User Defined Function (UDF) +0 VBA Macro Date/Time User Defined Function (UDF) VBA Macro Date/Time User Defined Function (UDF) VBA Macro
Select or Color Alternate Even/Odd Columns Custom Select Rows Columns +0 VBA Macro Custom Select Rows Columns VBA Macro Custom Select Rows Columns VBA Macro
Select or Color Alternate Even/Odd Rows Custom Select Rows Columns +0 VBA Macro Custom Select Rows Columns VBA Macro Custom Select Rows Columns VBA Macro
Convert Numbers to Text (To Append or Prefix Zero) Number +0 VBA Macro Number VBA Macro Number VBA Macro
Convert Numbers appearing as Text to their Values (Number Format) (Remove Green Sign) Number +0 VBA Macro Number VBA Macro Number VBA Macro
SuperScript or Subscript the First or Last Character of Text in Selected Range Cells Text +0 VBA Macro Text VBA Macro Text VBA Macro
Extract Alphabets (Remove Digits) from Selected Range Text User Defined Function (UDF) +0 VBA Macro Text User Defined Function (UDF) VBA Macro Text User Defined Function (UDF) VBA Macro
Extract Digits (Remove Alphabets) from Selected Range Number Text User Defined Function (UDF) + VBA Macro Number Text User Defined Function (UDF) VBA Macro Number Text User Defined Function (UDF) VBA Macro
Reverse the text in selected cells (Mirroring/Plain Encryption of Text) Text +0 VBA Macro Text VBA Macro Text VBA Macro
Force Save and Unsave of Workbooks Event Macro VBA Macro +0 Workbooks Event Macro VBA Macro Workbooks Event Macro VBA Macro Workbooks
UnProtect all WorkSheets in the WorkBook VBA Macro +0 Worksheets VBA Macro Worksheets VBA Macro Worksheets
Protect all WorkSheets in the WorkBook VBA Macro +0 Worksheets VBA Macro Worksheets VBA Macro Worksheets
Sort all worksheets on the basis of Sheet names VBA Macro +0 Worksheets VBA Macro Worksheets VBA Macro Worksheets