Start Updating vba

Updating vba

Queries will run in the background if the correct command syntax is used.

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

You might get away with pressing F9 to calculate Regards, TMS Trevor Shuttleworth - Excel Aid I dream of a better world where chickens can cross the road without having their motives questioned 'Being unapologetic means never having to say you're sorry' John Cooper Clarke You can probably call the function on a Selection_Change event.. Volatile might not work because the sheet does not re-calculate when the color is applied..

Selection_Change might be the only way I know where you will have to click somewhere else once for the code to get triggered...

How can I make them update/run/execute/whatever it's called, whenever a I change a the formatting of a row? Colour is not data so changing the colour won't initiate a re-calculation.