How to pass cell value in HTML code using VBA

[ThrottleWorks]

Hi,

How to change -007.07 with cell value. I tried Google but not able get the result properly.
Can anyone please tell me how do I replace -007.07 with range value.

-007.07 is amount and will keep changing so I need to pass a cell value for this.
I am not able to edit below mentioned line to get the proper results. Can anyone please help me in this.

strbody = strbody & "<p style='font-family:calibri;font-size:15;color:red'>For -007.07 Amount</p>"

 

[NARAYANK991]

Hi Sachin ,

Have you tried something like :

strbody = strbody & "<p style='font-family:calibri;font-size:15;color:red'>For " & [A1] & " Amount</p>"

where the cell A1 contains the amount ?

Narayan

 

[ThrottleWorks]

Hi @NARAYANK991 sir, thanks lot. It is working great. I was trying Range("A1") and cells(1,1) but it was not working.

Have a nice day ahead.

 

[NARAYANK991]

Hi ,

There is nothing such as Cell ; Cells is a property , and you need to use Cells(1,1)

Narayan

 

[YasserKhalil]

May be you tried Range("A1") only without .Value
So may be Range("A1").Value Or Cells(1,1).Value Or [A1]

 

[ThrottleWorks]

Hi @NARAYANK991 sir, yes you are right, it was typo from my side while posting here. I tried cells(1,1) but somehow it was not working. May be some mistake in syntax I was using.

Hi @YasserKhalil , thanks a lot for the help.