I would like to find a begiing and an end date in a range and then highlight all those cells included in the date range. I would like to use Set g1 = .Range("A1") Set g2 = .Range("C3")as advised in the link but my cell range changes, so a hard-coded "A1" or "C3" won't work. What would the above code look like utilizing variables instead?
