| 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 | |||
Linear Mode
