oops :) just saw the Range(Range() construct...
and was misled by the OP's phrase 'results in C6 getting'

to OP:
it's like Juan says... 'it can pull but it cant push'




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Juan Pablo González" wrote:

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