MrExcel Publishing
Your One Stop for Excel Tips & Solutions

printing to an excel cell


Posted by Colin on October 12, 2001 8:46 AM

Another quick question.

How can you get a macro to print a formula into an excel cell.
I need it to print the formula for a sum from two points i specified in the macro

I need the cell to look like
=SUM(K?:K?)
where the ?s are references to rows in the spreadsheet.

Any help is appreciated.


Posted by Todd on October 12, 2001 10:12 AM

Range("A1") = "=sum(k1:k100)"