Macro - Autofilter Change. [minor problem]

[samprince]

'
' Thursdays Macro
' Macro recorded 31/10/06 by Sam Prince
'

'
Sheets("PeakCounts").Select
Selection.AutoFilter Field:=2, Criteria1:="Thursday"
Sheets("Peak - Counts").Select
End Sub

^^ I'm using the above Macro to Change an Auto Filter on another Worksheet so that the charts on "Peak - Counts" reflect singular days. In the above example Thursdays.

These Macros work fine, however is causes the "PeakCounts" worksheet to flash up before changing back to "Peak - Counts"

Is it possible to alter this code in some way so that the flash between worksheets is not visible?

TY
SP.

[Bryan Hessey]

'
' Sheets("PeakCounts").Select
Selection.AutoFilter Field:=2, Criteria1:="Thursday"
Sheets("Peak - Counts").Select
End Sub

^^ I'm using the above Macro to Change an Auto Filter on another Worksheet so that the charts on "Peak - Counts" reflect singular days. In the above example Thursdays.

These Macros work fine, however is causes the "PeakCounts" worksheet to flash up before changing back to "Peak - Counts"

Is it possible to alter this code in some way so that the flash between worksheets is not visible?
TY
SP.

You could try

Application.ScreenUpdating = False

at the start, then

Application.ScreenUpdating = True

at the end, that should help hide that you 'Select' the two sheets.

---

[samprince]

Works a treat.

Many thanks.

SP.