Hi All,
I am new to VBA programming and I am getting Out of Memory Error 7
While I assign text to a named cell like here the text contained in
the variable is huge around 8 pages. I would really appreciate if some
one can tell me an alternative way to do.

Worksheets("worksheetname").Range("named").Value = variable


Thanks in advance.

Regards