[VBA] Absolute Value Formula
Solved
Palteza
Posted messages
82
Status
Membre
-
Palteza Posted messages 82 Status Membre -
Palteza Posted messages 82 Status Membre -
Hello everyone,
I need to enter formulas that refer to a different sheet into certain cells using VBA. I thought for a moment that using absolute references would be possible. So I tried the code below, perhaps naively, which does not work (knowing that my Column1 does indeed retrieve a letter):
Is there a way to keep this method by finding out what part is incorrect, or is it just not possible this way?
If it is impossible, what is the easiest way to do it (still keeping the absolute reference method if possible)? ... I'm thinking of Cells(x,y).Address ... but if you know a shorter way.
Thanks in advance.
I need to enter formulas that refer to a different sheet into certain cells using VBA. I thought for a moment that using absolute references would be possible. So I tried the code below, perhaps naively, which does not work (knowing that my Column1 does indeed retrieve a letter):
xlSheet2.Range("B8").Value = "=Données_Tous_Découpages'!$" & Colonne1 & "$2" Is there a way to keep this method by finding out what part is incorrect, or is it just not possible this way?
If it is impossible, what is the easiest way to do it (still keeping the absolute reference method if possible)? ... I'm thinking of Cells(x,y).Address ... but if you know a shorter way.
Thanks in advance.
