Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each cell - Variable not defined (VBA)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each cell - Variable not defined (VBA)
"Shlomit" skrev i en meddelelse
... 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 -- Best regards Leo Heuser Followup to newsgroup only please. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
For Each cell - Variable not defined (VBA)
Try declaring this before the code:
Dim cell as range or Dim myRng as range On Jan 25, 2:54 am, Shlomit wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
looping through variable defined cell | Excel Programming | |||
msoShapeRectangle -- Variable not defined ??? | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
[Q] msoShapeRectangle: variable not defined | Excel Programming | |||
Variable Not Defined? objPivotCache | Excel Programming |