Hi shovit,

Yes - you can use the Worksheet_Change event subroutine to do this. To get
there, just right-click the worksheet's tab in Excel and select View Code.
Then, change the left dropdown above the code module to Worksheet, then
change the right dropdown to Change. Call your macro from that subroutine,
and each time any cell on the Worksheet changes, your macro will be
executed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


shovit sahai wrote:
Hi,

I have a spreadsheet which is linked to live feeds from say Reuters. I
need to write a macro which auto-runs itself every time the
spreadsheet refreshes, or there is change in any of its cells.
Something to the effect "On every refresh, Do bla bla bla". Is there
a way to implement this in VB?

TIA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!