Hello everyone. I’m very new to VBA and I apologize, cause I’m going to make three separate posts to figure out the final issues with my project. On to the question.
My project is a schedule which spans from week 1-53 with the weeknum formula. In conditional formatting the current week is highlighted. I would like to have a macro which aligns the current week to the frozen A-C columns.
I’ve attached my project.
Thank you all for the help. I can’t express how much I appreciate it.
Bookmarks