| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
| AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
