How to highlight the current month through VBA?

N

Nikita072019-09-04 05:58:13

Macros

Nikita07, 2019-09-04 05:58:13

Good afternoon, how in Excel using macros, depending on the active cell with a date, select the entire month corresponding to this date?
Example: In the screenshot, a cell with 09/08/2019 is selected, how to select a range with September using VBA?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

stictt, 2019-09-04
@Nikita07

If my memory serves me, this can be done simply by the formula, = TODAY () the formula returns the current date, in the conditional design for the range you set if the date is equal to this date (today) then paint the cell. It's very simple