Program a macro to print

S

stevestr

I have an employee expense report that contains employee information in the
first five rows. The rows 6 through 30 are blank and for the employee to
fill in (or add additional rows if necessary) with a list of their expenses.

In rows 31 - 37, there is information that the employee acknowledges that
the expenses listed in the rows are true and incurred on behalf of his/her
job duties.

I have a macro that automatically prints this worksheet. If the employee
doesn't have enough expenses to fill all the rows between 6 and 30, I would
like to create a routine in my macro to look for the first blank in row A and
delete the blank rows until the macro finds a text entry in row B - which, if
all rows 6 through 30 have been used, cell 32B begins the text that follows
the expenses that the employee must sign verifying that expenses listed above
are correct and incurred on behalf of his/her job.

Thanks for your help!
 
D

Don Guillett

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top