Menu

Delete current month using AUTOFILTER

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

Delete current month using AUTOFILTER

Aw shucks, glad to help.

--
Don Guillett
SalesAid Software

"Mslady" wrote in
message ...

Brilliant!!!
thanks Don! this works perfectly. :)

Code:
--------------------
With Worksheets("DataTable")
startday = DateSerial(Year(Date), Month(Date), 1)
stopday = DateSerial(Year(Date), Month(Date) + 1, 1)
If .AutoFilterMode = False Then .Cells(1, 1).AutoFilter
.Range("A1").AutoFilter Field:=1, Criteria1:="=" & startday & "", _
Operator:=xlAnd, Criteria2:="<" & stopday & ""
.Range("A1").CurrentRegion.Offset(1, 0).SpecialCells _
(xlCellTypeVisible).EntireRow.Delete
.AutoFilterMode = False
End With
--------------------

Thanks also Ron, for that resource. i have it bookmarked, im sure it
will come in handy.

Thanks guys!

--
Mslady
------------------------------------------------------------------------
Mslady's Profile:
http://www.excelforum.com/member.php...o&userid=27776
View this thread: http://www.excelforum.com/showthread...hreadid=481904

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Current Month	Sr Accountant[_2_]	Excel Discussion (Misc queries)	1	September 5th 07 03:10 AM
Subtract a future month from the current month to get remaining m.	Fletch	Excel Worksheet Functions	1	July 26th 07 04:29 PM
Retrieve data for previous 3, 6, 12 month given current month	GB	Excel Worksheet Functions	4	July 19th 07 11:58 PM
Calculate the first day of the month for the current month?	April S.	Excel Discussion (Misc queries)	5	July 27th 05 08:53 PM
Current Month	Dave M.	Excel Programming	5	July 15th 05 03:23 PM

All times are GMT +1. The time now is 05:48 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement