Hi All

Any advice people could offer on the couple of porobably stupid
questions below would be much appreciated.

1- I have an existing macro that splits a worksheet down into data
specifically for a customer that i tell it at the beginning.
I know macro's can email stuff, and have worked out how to send the
file to a recipitent, with a subject, but i cant work out how to put in
some message text.
I cant really send the file automactically unless it has covering
message text...

2- Im trying to make another macro that finds the first title row in a
sheet, formats it, and then finds the next title row and does the same,
before moving onto the next sheet and doing the process again there.
Have made an input box to tell it where to start the first title row,
but cant work out how to make it find the next row.
Assuming somesort of Loop where it checks cell values vs a variable
sets as the first title row?
And when it has reached the bottom of the sheet, i need it to move to
the next sheet - how do i make it know where the end of the sheet is?

Also how do i make it stop once it reaches the final sheet?

Thanks!!!


--
iambalrog
------------------------------------------------------------------------
iambalrog's Profile: http://www.excelforum.com/member.php...o&userid=26977
View this thread: http://www.excelforum.com/showthread...hreadid=494080