Forum Discussion

Copper Contributor

Apr 06, 2020

VBA To Highlight Rows

Hi We have a piece of software that outputs an Excel file once a week, this file has to be organised and edited to show specific information, which is quite a tedious task! I am trying to produc...

excel

Macros and VBA

mtarler

Silver Contributor

Apr 06, 2020

BTW I did some testing that way and it appears that could be the problem and you could solve the problem by using cdate(cell.value)

TattyJJ

Copper Contributor

Apr 06, 2020

mtarler

GOT IT!!!

By converting all the dates in column E to number format, then using CLng(Date) to do the comparison with all the dates as integers, then turning them back into dates.

Seems a bit long winded, but it does the job...

Thanks for your help!