Ask Experts Questions for FREE Help !
Ask
    sue991's Avatar
    sue991 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 6, 2011, 12:34 PM
    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

Check out some similar questions!

Columns of data in Excel into rows of data [ 6 Answers ]

Hi, I have 2 columns (column A, column B) of data in Excel. I need to make the data into row in such arrangement column A1 goes to row 1, column B1 goes to row 2, column A2 goes to row 3, column B2 goes to row 4, and so on). I have over 1000 records in column A and column B to make that happen. Any...

Excel Macro [ 13 Answers ]

I have some code that loops through a row and a column and compares data. When it finds the values being equal it copies the columns the row is in and pastes it on another sheet along with the previous value of the column. For Each CCell In Range("C2:C65418") If Not IsEmpty(CCell.Value)...

Excel macro [ 4 Answers ]

I need to run a macro that opens excel so I can kick off "application.ontime" basically my macro should run without me having to start excel, just have the computer and outlook running. Is that possible?

Recording a macro in Excel [ 2 Answers ]

Need a macro that will select the cell one place to the left, edit the content, hit enter, and then move to cell below where started and repeat to end of column (last cell with a value). Example: 123-456789 is format of cell to be edited - need to remove the hyphen. Someone had created it...

How to Automate a macro in excel [ 4 Answers ]

A program logs files at random in txt. abc_log.txt (example) When new info. Is added to the txt file,manualy activate macro and it does what it suppose to do, all OK there. Is there a way a macro code or excel, or perhaps a BAT program can be made to simply "detect" when new data is added...

View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.