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

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