I forgot what the rest of the 1004 error said... something abou
"Application Function..." cant remember.

I know this VBA Code is shameful... but just learning.

"If Range("D7").Value < "" Then"

I just wanted the program to start running if cell D7 was empty but i
not empty then to end the program and do nothing.

Thanks for your help... now how do you include the other sheets in th
code?

Larry
VBA Amateu

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