Anders,
Thanks for baring with me. The spread sheet columns has the parts no.
and the rows gets filled in as the data is entered. I am targeting
particular column (say column F) which has an embeded formula to adjus
the inventory of an item. Once any part get sbelow set minimum level.
My script captures it and copy the relevant info cells of that item an
puts into another sheet and prints it.
Debra's idea of (dynamic range) for DATA FORM worked and I am almos
getting there..
saziz;

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