Thread: How to calculate time to rum a macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
  
Posts: 638
Default How to calculate time to rum a macro?
Dim sTime as Single
sTime = Timer
'your code here
MsgBox Timer-sTime

Madiya wrote:
I have few langthy macros which are taking around 2-3 min.
I want to calculate the exact time taken by macro.

Regards,
Madiya

Reply With QuoteReply With Quote