Macro Help
 

Hi:

I have a macro that was created in Excel 2000. I am now running it in Excel
2007. When I run the macro which opens a file and formats it, I get a debug
error message. Can someone tell me what this code is doing?

Columns("E:E").Select
I = 1
While UCase(Left(Sheets(1).Cells(I, 5).Value, 2)) < "EA"
I = I + 1
Wend

Any help would be appreciated.

Macro Help
 

That bit of code is looking down Column 5 (column E) in sheet 1 until it gets
to a cell which doesn't start with the letters "EA"

Presumably something happens after this using the variable I, which will
point to the row after the EAs have finished.


"Theresa" wrote:

Hi:

I have a macro that was created in Excel 2000. I am now running it in Excel
2007. When I run the macro which opens a file and formats it, I get a debug
error message. Can someone tell me what this code is doing?

Columns("E:E").Select
I = 1
While UCase(Left(Sheets(1).Cells(I, 5).Value, 2)) < "EA"
I = I + 1
Wend

Any help would be appreciated.