If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA - If formula

Thread starter tanyaleblanc
Start date May 21, 2019
Tags

.autofilter column current date enter

tanyaleblanc

Board Regular

May 21, 2019

Hi, I"m trying to create coding that says, filter column 3 for anything other than N/A's, if Payout is populated, enter Yes in those columns of AA, if Takeover, enter Yes in column AC. I don't have an IF formula either, but that's what I would like.

When I enter the code below, it's entering the word Yes in cell AA2, which is the header row.

Code:

With Windows("Rental Rec.xlsm")
    Sheets("Owned").Select
     lRow = Cells(Rows.Count, "G").End(xlUp).Row
     With Range("a2:bh" & lRow)
            .AutoFilter
             .AutoFilter Field:=3, Criteria1:="<>#N/A"
Range("AA4:AA" & lRow).SpecialCells(xlCellTypeVisible) = "Yes"
'it didn't copy all the way down, short 8 rows, giving two different formats for dates, as well,
'want to say, if data in column c enter current date in column aj (date should be 15th of current month)
With Selection
Range("aj3:aj" & lRow).Value = Now