Add Dollar Sign “$$” in Excel Sheet by One Click (in 1 Second) Apply Dollar Sign in Bulk

Here is the VBA Code to Add Dollar Sign “$$” in Excel Sheet by One Click with VBA Code:

Sub InsertDollarSigns()
Dim cellRange As Range
For Each cellRange In ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas)
cellRange.Formula = Application.ConvertFormula(cellRange.Formula, xlA1, xlA1, True)
Next
End Sub

Download VBA Code Here

Download this Code

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment