Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel macro filters out all data (https://www.askmehelpdesk.com/showthread.php?t=617412)

  • Dec 6, 2011, 12:34 PM
    sue991
    excel macro filters out all data
    Range("A1").Select
    Application.CutCopyMode = False
    ActiveCell.Offset(1, 0).Select
    Do Until ActiveCell.EntireRow.Hidden = False
    ActiveCell.Offset(1, 0).Select
    Loop
    With Selection.Font
    .Color = -16776961
    .TintAndShade = 0
    End With
    ActiveSheet.Range("$A$1:$A$500").AutoFilter Field:=1, Operator:= _
    xlFilterAutomaticFontColor
    Range("A1").Select

    Above is the macro I wrote to change the colour of the data in cell A2 and then filter out that data however on some spreadsheets it works, on others it filters out all data. Any ideas why?
    Thanks

  • All times are GMT -7. The time now is 02:50 AM.