Mhm... maybe, but the VBA code puts "Lotus" in C6..., hence my comment.
(Unless the OP puts ="Lotus" in C6 <g )

--
Regards

Juan Pablo González

"keepITcool" wrote in message
...
I think OP measn something different.

cell a1 contains the string "c6"
cell c6 contains "Lotus"

formula =indirect(a1) will result in "Lotus"


keepITcool