Problems with For Each
 

I have the code below but it gives me an error and tells me to defin
the variable 'cell' in the For Each cell In Selection part. Why is i
doing that?


Code
-------------------
LRow = Cells(Rows.Count, "E").End(xlUp).Row
Range("A2:A" & LRow).Select
' START CHANGE NUMBER TO TEXT
For Each cell In Selection
cell.NumberFormat = "@"
cell.Value = Trim(cell.Value)

' If cell.Value < "" Then
' TempString = Trim(UCase(cell.Value))
' cell.Value = TempString
' End If
Next cel
-------------------

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=39345

Problems with For Each
 

Hi DKY,

If you're using Option Explicit, you'll have to declare "cell" as an Object
or Range variable. So put the following line of code above your loop and
you should be fine:

Dim cell As Range

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


DKY wrote:
I have the code below but it gives me an error and tells me to define
the variable 'cell' in the For Each cell In Selection part. Why is it
doing that?


Code:
--------------------
LRow = Cells(Rows.Count, "E").End(xlUp).Row
Range("A2:A" & LRow).Select
' START CHANGE NUMBER TO TEXT
For Each cell In Selection
cell.NumberFormat = "@"
cell.Value = Trim(cell.Value)

' If cell.Value < "" Then
' TempString = Trim(UCase(cell.Value))
' cell.Value = TempString
' End If
Next cell
--------------------

Problems with For Each
 

Oh, I just removed Option Explicit. What's Option Explicit for anyway

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=39345

Problems with For Each
 

Hi DKY,

The Option Explicit statement requires that all variables be declared and
that the be declared explicitly.

See Chip Pearson's 'Using Variables (Properly) In VBA' page at:

http://www.cpearson.com/excel/variables.htm

for a detailed discussion of the issue.

Perhaps, prior to reading the above, you might profitably visit Chip's
'Declaring Variables In VBA' page at:

http://www.cpearson.com/excel/DeclaringVariables.htm


---
Regards,
Norman



"DKY" wrote in message
...

Oh, I just removed Option Explicit. What's Option Explicit for anyway?


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=393455

Problems with For Each
 

DKY

I asked the same question. Here is the answer.

http://www.excelforum.com/showthread.php?t=384692

this Help?
Dave
DKY Wrote:
Oh, I just removed Option Explicit. What's Option Explicit for anyway?


--
Piranha
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=393455