Need multiple date stamps in ColA

I'm appending data to rows (ColB:ColL) in one w/s from another. Each time rows are appended I want a date stamp in ColA to be entered automatically. When multiple rows are appended the following code only puts the date in the first appended row.

Please Login or Register  to view this content.

Thanks,
roothog

Maybe try something like this...

Please Login or Register  to view this content.

That worked AlphaFrog, in putting the time stamp in each row copied. I didn't think it would make a difference and should've noted, but the data appended most often has blank rows at the bottom of the copy/pastespecial (19 rows copied each time filled top down). So, if the row is blank (always at the bottom) there needs to be no date stamp.

Please Login or Register  to view this content.

a b s o l u t e l y perfect! thanks AlphaFrog for you time and knowledge for solving my problem!

roothog