Offset row

[ChristineJ]

I am using this code to pull in the value in cell LM in the same row.

strTitle = IIf(CStr(Range("LM" & .Row)) = "", " ", (CStr(Range("LM" & .Row)) & vbCr))

How can this be changed so it pulls in the value in cell LM, but 25 rows up? (So if the cell is in row 50, it pulls in the value of LM25, for example.)

Thanks.

 

[Snakehips]

ChristineJ,

Try change .Row to .Row - 25

Hope that helps.

 

[ChristineJ]

Works perfectly! Thanks so much for the quick reply. CJ