Posts

Calculate Business Working Days between two dates (Excluding Saturdays and Sundays)

Select or Color Alternate Even/Odd Columns

Select or Color Alternate Even/Odd Rows

Change Polarity or Number Sign

Convert Numbers to Text (To Append or Prefix Zero)

Convert Numbers appearing as Text to their Values (Number Format) (Remove Green Sign)

Convert Formulas to Values

SuperScript or Subscript the First or Last Character of Text in Selected Range Cells

Rainbow color the Text

Extract Alphabets (Remove Digits) from Selected Range

Extract Digits (Remove Alphabets) from Selected Range

Reverse the text in selected cells (Mirroring/Plain Encryption of Text)

Use of Random Function (Rnd) and Select Case statement

Delete or Remove Event Macros, VBA Code and Module

Force Save and Unsave of Workbooks

Invert the Selection

UnProtect all WorkSheets in the WorkBook

Protect all WorkSheets in the WorkBook

Sort all worksheets on the basis of Sheet names