Hello!
I have searched far and wide for the perfect Code. I am very new to the use of VBA and Macros but I dream big when designing spreadsheets.
I have a sheet that has names going down the rows (A7:A257) with dates (month - year) going across the columns (E5:AN5).
I would like to run a macro which looks at each dated column and hides all columns not in the cureent month. (Ex: It's November. Hides months Jan-Oct and Dec)
Many thanks![Smile :smile: :smile:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I have searched far and wide for the perfect Code. I am very new to the use of VBA and Macros but I dream big when designing spreadsheets.
I have a sheet that has names going down the rows (A7:A257) with dates (month - year) going across the columns (E5:AN5).
I would like to run a macro which looks at each dated column and hides all columns not in the cureent month. (Ex: It's November. Hides months Jan-Oct and Dec)
Many thanks
![Smile :smile: :smile:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)