VBA question

[crazyowl86]

I have two sheets. On sheet one, column B starts from row 6 with a list of dates. On sheet two, column D starts from row 2 with another list of dates. I am trying to create a macro that highlights the whole row starting from column D in sheet one if there is a match between the dates in sheet one and sheet two. Can anyone help me with this? I would greatly appreciate any advice or help.

 

[6StringJazzer]

Any reason this has to be VBA? It could be done easily with conditional formatting.

 

[crazyowl86]

Just because there are cells constantly being added to and deleted from this file, I thought using VBA might just automate the process.

 

[6StringJazzer]

the whole row starting from column D in sheet one

what columns are being used?

 

[crazyowl86]

D:HY

 

[6StringJazzer]

I am still unclear as to why you can't use conditional formatting for this.

On sheet one, column B starts from row 6 with a list of dates. On sheet two, column D starts from row 2 with another list of dates. I am trying to create a macro that highlights the whole row starting from column D in sheet one if there is a match between the dates in sheet one and sheet two. C

Select all columns to be highlighted on sheet one and apply this rule:

=AND(ROW()>=6,ISNUMBER(MATCH($B1,'sheet two'!$D:$D,0))

This will be impervious to rows being added and deleted.