hi flurry
You can install EasyFilter to filter and copy to a new sheet
http://www.rondebruin.nl/easyfilter.htm
Or code here
http://www.rondebruin.nl/copy5.htm#one
use code like this in this macro
rng.AutoFilter Field:=1, Criteria1:="=" & DateSerial(1947, 2, 23), _
Operator:=xlOr, Criteria2:="<=" & DateSerial(1988, 5, 7) ' yyyy-mm-dd format
Then you can send that sheet with my SendMail add-in or with code from this page
http://www.rondebruin.nl/sendmail.htm
--
Regards Ron De Bruin
http://www.rondebruin.nl
"flurry" wrote in message
...
I'm trying to create a macro to look for a start date and end date in
one column and copy the rows that fall in between onto another sheet. I
then need to set another macro that emails that as an attachment. Any
ideas would be much appreciated! p.s. I'm very new to VBA!
--
flurry
------------------------------------------------------------------------
flurry's Profile: http://www.excelforum.com/member.php...o&userid=34303
View this thread: http://www.excelforum.com/showthread...hreadid=548113