select row range????

hello again,

i have a question that could take some answer.

- i have a form that has a button which says 'print'.
- i have a sheet that takes a 'booked in date' (from a form), and a sent out date (from another form).
- now, when i click print (on my main form), i want to select all the rows that have a 'booked in date' but NO 'sent out' date and prompt to print.

can anyone help. i think i can handle the prompt to print but i can't figure out the select rows if 'sent out' is empty.

thank you muchly.
spinkung

You just need to nest some if statements. Using english...

select top of range containing data.
step through the range until end of range is reached.
if booked in date <>"" then
    if sent out date ="" then
         print this document
    end if
end if
loop to next row.