LinkBack URL
About LinkBacks
I want to activate a macro when my =INT(VALUE(MID(NOW(),6,6))*24) formula ( ie the hour ) changes in cell A1.
Worksheet change event won't do it ... is there anything that will ??
Any help would be appreciated.
Colin
Autorun Macro when formula in cell updates
I want to activate a macro when my =INT(VALUE(MID(NOW(),6,6))*24) formula ( ie the hour ) changes in cell A1.
Worksheet change event won't do it ... is there anything that will ??
Any help would be appreciated.
Colin
You'd need to use the OnTime method to schedule the macro to run at the appropriate time. There are good examples in Help.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks