View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
k. moran k. moran is offline
external usenet poster
 
Posts: 8
Default Application.Volatile Question, HelP!!!

Okay here's my problem,

I have a VBA subroutine (Marco) that I want to run, BUT in my worksheets I
also have functions that I've written (in VBA) that are Application.Volatile.

So when I run the subroutine, Excel also has to re-calculate "all" the
functions in all cells that are in all the worksheets.

What happens is that everything grinds to a halt!

What can I do???

Much Thanks As Always! Kurt

Function TotalPCRs() As Integer

Application.Volatile