Narrative Comment with a Cell Reference
 

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

Narrative Comment with a Cell Reference
 

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

--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DOUG" wrote:

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