|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
This code will color the first empty cell in the range A1:A10 yellow. When
the empty cell is found, the routine exits.
Dim Rng As Range
For Each Rng In Range("A1:A10")
If IsEmpty(Rng) = True Then
Rng.Interior.ColorIndex = 6
> What is the code for a makro to look for the first empty
> cell in column A?
|Thread||Thread Starter||Forum||Replies||Last Post|
|Can I start a macro from a cell by using a formula||PraxisPete||Excel Worksheet Functions||1||April 8th 05 08:57 AM|
|Syntax for inferred cell references||donesquire||Excel Worksheet Functions||4||April 4th 05 09:29 PM|
|A Macro that will cut and paste to specific cell||VBA12thRoundDraftPick||Excel Discussion (Misc queries)||1||March 31st 05 06:11 AM|
|show macro security setting in a cell||Mark||Excel Worksheet Functions||3||March 21st 05 07:53 AM|
|Macro - - Automation||Jac||Excel Discussion (Misc queries)||8||December 27th 04 02:42 PM|