Use auto filter and then delete the rows.
Regards, Dave S
----- Original Message -----
From: "Farid" <adler666608@yahoo.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Friday, July 15, 2011 9:56 PM
Subject: [ExcelVBA] Excel VBA code for deletng rows that contain hours
within special range?
> Hello, I have an excel list of workers and the hours they spent at work. I
> need to delete rows of workers who spent at least 10:00:00 hours. The
> format of time is "hours:minutes:seconds". Thanks
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1390 / Virus Database: 1516/3763 - Release Date: 07/13/11
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar