MANAGING MACROS
 

i have recorded a macro until the point i have to choose a particular date using the auto filter command
how can i continue recording the same macro after i have chosen the date i want? is that feasible or do i have to record a macro without intervals

MANAGING MACROS
 

Hi Angie,

You should have tried it<VBG.

You can record that action as well, and continue recording. The date you
pick will be input into the recorded macro.

Dates do pose a problem though, due to international settings. When you
record the macro, the criteria will be a string similar to this "<25-Feb",
where the format reflects the format of your date column The problem comes
if you want to change this to a variable value in your macro, such as
Today. I did this with a similar problem, and the way I got around it was to
set the criteria format to the same format as the first date in my filtered
column, like this

Columns(1).AutoFilter Field:=1, Criteria1:="<" & Format(Date,
Range("A2").NumberFormat)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"angie" wrote in message
...
i have recorded a macro until the point i have to choose a particular date
using the auto filter command.
how can i continue recording the same macro after i have chosen the date
i want? is that feasible or do i have to record a macro without intervals?