View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert Bruce[_2_] Robert Bruce[_2_] is offline
external usenet poster
 
Posts: 108
Default macro runs counting

Roedd <<sisco98 wedi ysgrifennu:

My problem is that I 'd like that the excel would counting the number
of runs of a macro in a certain cell. For example, there is the cell
"B4" with number 1. I run a macro and when it's ended, the valu of
"B4" cell is increasing by 1 and it will be 2.


range("B4").value = range("B4").value +1 as the last line of your macro?

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.