hi

i have a data valisation in sheet " Data Entry" in C3 it is dynamic from AD7 " =OFFSET($AD$7,0,0,COUNTA($AD:$AD),1) " , can be any number of rows.

VB should be in this order

if A3 is " (ALL)" then A3 = AD8 then -- run Option Explicit Sub ShowList() ---- wait 10 seconds -- then Print -- next go to AD8 , A3= AD8 , run Sub Showlist() , Print ......... so on, if the cell is empty stop.

i will creat a button to run that macro, like Sub Print()

Any help please.

mostakim