Re: Using the .Replace funktion on hidden cells.
I have also tried this code
Code
Sub Makro_Replace()
Columns("K:K").Replace What:=");;", Replacement:="="""");;", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
It did not work.
I have tried on a sheet with no rows or columns hidden and it still do not work.
It does work when I do it manual.
I am trying to change this formula
=OM(ELLER(Försäljning!$C$7="";$C$7);;C28*$C$7/Försäljning!$C$7)
to this
=OM(ELLER(Försäljning!$C$7="";$C$7="");;C28*$C$7/Försäljning!$C$7).
There are approximately 58 formulas and each differense a little (the row no after C).