Thread: Macro Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Theresa Theresa is offline
external usenet poster
 
Posts: 55
Default 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.