Help with my first macro please
I have the following in my first macro: Selection.AutoFilter Field:=2, Criteria1:="20-Nov", Operator:=xlAnd Range("C11:C214").Select which works fine. However, what i would like is for the date to change to today whenever I run it. At the moment I have to update it manually. Does anyone know how I can do this? Many thanks in advance Debbie ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Help with my first macro please
This may do it:
Selection.AutoFilter Field:=2, Criteria1:="" & Int(Now) -- Jim Rech Excel MVP |
All times are GMT +1. The time now is 12:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com