Use Replace

MyString = Replace(MyString,"$","")

"DontKnow" wrote:

Hi Guys,

I need help to search and find all the "$" in a range so as the outpuit
looks like this

"A10:AG10"

At the moment the unwanted string looks like this

"$A$10:$AG$10"

Is their a way that I can be rid of the $ from my string range.

I have tried instr command and then deleting the found value etc but it is
rather cumbersome.

Can someone help me??

Many thnaks for your input in advance!!

Cheers,