Changing formulas to absolute references and, if not possible, converting them to mixed references.

[Josecarlospdcj]

Olá pessoal!
O código VBA que tenho no momento muda "L15" para "$L$15" nas células "A1" e "B1".
Preciso que “L15” tenha uma referência absoluta, também, em outras células (A2:B3), e quando não for possível, opte por uma referência mista (ex. na célula A2: “=L15+ML15” para “$L $ 15+ML $ 15”).
A B C

=L15+L16	=L15+L16	=M15+M16
=L15+ML15	=L15+TL15	=M16+M17
=L15+L16	=L15+M16	=M17+M18

Sub-a10092023()

ThisWorkbook.Activate
Planilhas("Plan1l").Ativar
Intervalo("A1:C10").Substituir o que:="L15", Substituição:="$L$15"

Finalizar sub

 

[Josecarlospdcj]

Correcting VBA code:

Sub a10092023()

ThisWorkbook.Activate
Worksheets("Plan1l").Activate
Range("A1:C10").Replace What:="L15", Replacement:="$L$15"

End Sub

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Changing formulas to absolute references and, if not possible, converting them to mixed re

Hello everybody! The VBA code I have at the moment changes "L15" to "$L$15" in cells "A1" and "B1". I need ?L15? to have an absolute reference, also, in other cells (A2:B3), and when it is not possible, go for a mixed reference (e.g. in cell A2: ?=L15+ML15? for ?$L$15+ML$15?). A B C 1...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Josecarlospdcj]

I sincerely thank you for understanding my transgression of the rules.

 

[Josecarlospdcj]

I clearly understood what I should have done and why I will not be a repeat offender.
I sincerely apologize for what happened.