Thread: hi, i need help , i want to create a macro that take snapshots
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default hi, i need help , i want to create a macro that take snapshots
Use application.OnTime

See Chip Pearson's page on Application.OnTime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy



"ritu" wrote:

i want to create a macro that take snapshots of a sheet at regular
interval. is there a function which takes the snapshots and how do i
link up my computer time with my sheet so that the counter could be
incremented after one hour to take the snapshot of a sheet.


Reply With QuoteReply With Quote