Thanks Mark,
You are correct the named range here is just a single cell, and I am
retrieving data from Lotus notes Database to be assigned to a variable
and then variable's value is assigned to the named cell(single cell
B16).
Worksheets("worksheetname").Range("named").Value = variable
In one particular case the data that is retrieved from the db for
this variable is 8 pages long when pasted into a word document. Is
there any turn around to put all that text into one cell ?.

Your help is really appreciated.
Thanks again.

Please let me know.

Regards