Prev: Timer that auto-closes workbook?
Next: seperate
From: ytayta555 on 22 Feb 2010 09:44
On 22 feb., 16:19, "Charabeuh" <Ple...(a)FeedBack.fr> wrote:
> hello,
> When using the function, it works the first time.

INDEED . I was busy to check it

> I added Application.volatile in the code of Mike H .....

I use this code :

Sub MYMACRO()

Dim myCell As Range
Dim myRng1 As Range
Set myRng1 = Range("A1:E30")

For Each myCell In myRng1.Cells
If myCell <> vbNullString Then
myCell = "=countnull()"
End If
Next myCell

End Sub

and now , IT WORKS great .

I have to thank you - to all three - very much ,
that you used and shared your knowledge and time
helping me . I wish you a good week
First  |  Prev  | 
Pages: 1 2
Prev: Timer that auto-closes workbook?
Next: seperate