ActiveCell.Formula modification

[krishna334]

Hi Experts,

In one of the cells i have the below formula :

ActiveCell.Formula = _
"=""Hi," & Chr(10) & "" & Chr(10) & "Good Day!" & "Please confirm the PO# "" & A2"


What i need is, the last A2 in the formula is not constant i want to use somethig like A & i where "i" will vary.
So, how can i change the formula?

Thanks in advance

Regards

Krishna Kumar

 

[steve the fish]

So you just have text in the cell? You need a way to assign i. I just used a constant here:

i = 10
ActiveCell.Value = "Hi," & Chr(10) & Chr(10) & "Good Day! " & "Please confirm the PO#" & Range("A" & i).Value

 

[krishna334]

Fantastic!! This is what I wanted.

Thanks a lot Steve!!

 

[krishna334]

I think a made a mistake..

I want the formula also to be seen there with A2 being called after the code execute. It does not show the formula now.
Can you do please help me with that?

 

[Fluff]

Something like

Sub krishna334()
   Dim i As Long
   
   For i = 2 To 10
      Range("B" & i).Formula = "=""Hi,"" & Char(10) & Char(10) & ""Good Day! Please confirm the PO# "" & A" & i
   Next i
End Sub

 

[krishna334]

Thank you Fluff.

It works!!

 

[Fluff]

You're welcome & thanks for the feedback