VBA to loop through range to find date closest to today's date

**esbencito** · 11-05-2017, 11:01 PM

Hi all,

I am trying to write a code that loops through a range (CG1:CR1) of cells (which include certain dates) to find the cell/date that is closest to but smaller than today's date and then run a certain Macro. It should NOT run the Macro e.g. APR_17 if today's date is 06th November 2017 and run NOV_17 instead...

Please Login or Register  to view this content.

**protonLeah** · 11-06-2017, 01:42 AM

Please Login or Register  to view this content.

**jindon** · 11-06-2017, 02:08 AM

Please Login or Register  to view this content.

VBA to loop through range to find date closest to today's date

LinkBack

Thread Tools

Rate This Thread

Display

VBA to loop through range to find date closest to today's date

Re: VBA to loop through range to find date closest to today's date

Re: VBA to loop through range to find date closest to today's date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Match using today's date or next closest date

[SOLVED] Find closest date to today in a row of dates

[SOLVED] Formula to find date closest to today

[SOLVED] look-up a date in a range and find the date that is closest todays date

[SOLVED] Find Entry With Closest Date and Time to Today

Find last date in range (with blanks) that is less than TODAY()

find closest date (number) in a range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions