Prince, David and Viney,
Thanks for trying to help me.
Unfortunately it didn't work...
In teory, it seems to be really simple.
If I do it manualy in Excel plan sheet (Ctrl + U), it works fine...
But when we go to VBA, something is missing.
I will keep trying.
Best regards.
André Luiz D´Avila
hi Andre,
i have made it by selecting complete sheet/ all cells
just try if it works for you
Cells.Select
Selection.Replace What:="#", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A1")
The problem is that you are replacing a string with another string when you
want to replace it with a formula
So Try
ActiveCell.formula =Replace(ActiveCell.Value,"#","=",1,,vbTextCompare)
Regards
David Grugeon
On 16 March 2013 04:10, André D'Avila wrote:
> Hey Prince, thanks for the answer
Hey Prince, thanks for the answer.
I tryed here, but have no sucess...
The problem is pasting the information inside a cell.
I Have a string like -> *#Sum(a1:a2)* but then i take of the "#" (via
macro) and put a "=" sign then it doesnt recognize.
Replacing the "=" sign to "#" character is ok. R
Just Create a macro and passed your range, each cells with loop where i
have used ActiveCell.value
Replace(ActiveCell.Value,"#","=",1,,vbTextCompare)
Regards
Prince
On Friday, March 15, 2013 12:49:03 AM UTC+5:30, André D'Avila wrote:
>
> Guys, please help me.
>
> Inside VBA, i want to replace
