For Each cell - Variable not defined (VBA)

[Guest]

Hi,

I wrote code that inclue :
For Each cell In myRng
....
next
I got error "Variable not defined" and I don't find the reason.
(I some cases it's work but I didn't seccess to recognize when).

Please help, thanks
Shlomit

 

[Leo Heuser]

Hi,

I wrote code that inclue :
For Each cell In myRng
...
next
I got error "Variable not defined" and I don't find the reason.
(I some cases it's work but I didn't seccess to recognize when).

Please help, thanks
Shlomit

Hi Shlomit

Try this:

Dim cell As Variant

For Each cell In myRng.Cells

 

[Thulasiram]

Try declaring this before the code:

Dim cell as range
or
Dim myRng as range