if Target.Column.count = 1 and Target.Column = 1 then
should be

if Target.Columns.count = 1 and Target.Column = 1 then

make the first column plural (columns)

--
Regards,
Tom Ogilvy

"Sridhar Pentlavalli via OfficeKB.com" wrote in message
...
Hi Tom,

Thank you for the help. I am getting the error

"Compiler Error"
"Invalid Qualifier"

and "Column" is highlited in the expression "Targer.Column.Count"...

Can you help me ....

--
Message posted via http://www.officekb.com