Jake you are right. When choosing a few cells at the same time o
copying a value to a few cells at a time via "copy - paste", th
"Target" range is a multiple range and not the first cell.

I checked that with a msgbox "target= " &Target.address
and the address was a multiple range.

Your solution with intersect didn't help though. I will try just to d
a simple:

set My_Range = Target

for each My_Range in sheet1.Target etc...

Will post if it works.

Thank you so fa

--
Message posted from http://www.ExcelForum.com