DateAdd Help

[abktw2]

Hello,

I am looking to create a macro that will look through column BJ which has a series of date in it. I need it to select any row that the cell in column BJ is 30 days before today then cut those selections. I am just gettting familiar with the DateAdd function, but it is taking some time.

Adam

 

[abktw2]

Sorry one more thing. If it could just select cells in that row between A:BJ it would be more helpful than the entirerow command.

 

[Jonmo1]

You shouldn't really need the dateadd function...

Try

If Date - Range("BJ1") >=30 Then...

 

[abktw2]

Jonmo-

I am sorry I should have been more detailed. I am still very new to this whole VBA thing. I am trying to teach myself out of a book (poorly written mind you) and am not sure how to start it or what the if statement would be.