For some reason I'm having a hard time coming up with an easy macro for this, but seems like it should be simple.
All I want to do is:
-Check all rows in a spreadsheet
-If the value of any cell in column C is "False", then delete the contents of column A in the same row
For example, if C2 is "False", clear the contents of A2...then move down the spreadsheet doing the same thing to all rows (indefinite number of rows)
Macro was taking too long to figure out.
Ended up resorting to a formula entered into D2 and copied down: =IF(C2,A2, " ")
That created a new column for me where basically if the value of the C cell was false, the cell would be blank, and if true, it contains the value from A2.
I'll just use that as a workaround for now.
You can use AUTOFILTER for things like this. This should get you there, or close enough for you to finish:
Option Explicit Sub FilterOutFALSE() Dim LR As Long With ActiveSheet .AutoFilterMode = False .Rows(1).AutoFilter 3, "False" LR = .Range("A" & .Rows.Count).End(xlUp).Row If LR > 1 Then .Range("A2:A" & LR).Value = "" .AutoFilterMode = False End With End Sub
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks