select cell range??

[spinkung]

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

[Bryan Hessey]

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

Hi,

Perhaps a macro that will examine the required area and 'Hide' all rows that do not fit the print condition, do the print, then un-Hide all rows.

hth
---