Posted to microsoft.public.excel.programming

Helmut

external usenet poster

Posts: 111

do loop until empty cell

I want to execute the following until the cell in Column E is EMPTY.

Range("E11").Select
ActiveCell.FormulaR1C1 = "=+jan!RC+jan!RC[2]" (where jan is the
'PREVIOUS' sheet
Range("G11:H11").Select
Selection.ClearContents
Range("E12").Select
ActiveCell.FormulaR1C1 = "=+Ã©Ã°Ã¥Ã*Ã¸!RC+Ã©Ã°Ã¥Ã*Ã¸!RC[2]"
Range("G12:H12").Select
Selection.ClearContents
Range("E13").Select

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loop until cell is empty	Ricky Pang	Excel Programming	6	May 12th 06 05:14 PM
Loop to find next empty cell to the right not working.	Casey[_84_]	Excel Programming	3	May 4th 06 03:16 PM
having probelms getting my loop to terminate on an array value read from an empty cell	mizcrab	Excel Programming	3	November 30th 05 02:54 AM
Loop all sheetsand delete empty rows	Sige	Excel Programming	2	July 27th 05 12:22 PM
Empty cells in For Loop	Linking to specific cells in pivot table	Excel Programming	2	May 16th 05 07:25 PM

All times are GMT +1. The time now is 06:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us