Narrative Comment with a Cell Reference

[DOUG]

How would I place a cell reference within a narrative comment in another
cell? For example, "Family Practice workload in Jan increased by X%". (This
is in a Comments column in the far right-hand side of a spreadsheet). I
would like to write a macro to update the month by one and to use the cell
reference where "X%" resides to update the narrative comment. Please advise.
(I believe "Concantenate" is the key, but I am not sure of the VBA
statement).

DOUG

 

[Sheeloo]

Assuming A1 has the percentage you can use code fragment (this will work on
the ActiveSheet) to place the result in Z1

i=1
j=1
cmt = "Family Practice workload in Jan increased by " & Cells(i,j)
cells(1,26)=cmt