Forum Discussion
Macro problem not dynamically updating....
Hello there, I've got a tricky problem (for me) that I can't seem to solve. I'm trying to dynamically update a "goto" function in a macro. This is so that the macro updates as the date changes on eac...
Your schedule contains many modules and codes that seem to come from your recordings. Not sure on where you want to trigger the scroll macro, but perhaps that the attached simple example will help you solving your problem. I determine the row where todays date occurs with MATCH, and pick it up (named range) as a variable in the macro.
Riny_van_Eekelen Thanks very much Riny for taking the trouble - much appreciated. I think I follow your method, but if not, I can always just use it - as it seems to have populated my own macro library - not quite sure how that works - but hey - it has.
All the best. Feel free to pass on the spreadsheet..... if it's useful.
Kind regards Philip Andrews.
