Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find empty cell then stop
Hi,
I'd like to have a macro that does this: 1) for cells in column F that is a) not empty & b) greater than 3000000, search thru column K for the first empty cell. If there is, a message box to be shown for the cell address. Then the whole macro should stop. Thanks, Dolphin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find empty cell then stop
Perhaps?
Sub TryNow() Dim myR As Long Dim i As Long myR = Cells(Rows.Count, 6).End(xlUp).Row For i = 1 To myR If Cells(i, 6).Value 3000000 And Cells(i, 11).Value = "" Then MsgBox Cells(i, 11).Address Exit Sub End If Next i End Sub HTH, Bernie MS Excel MVP "Dolphinv4" wrote in message ... Hi, I'd like to have a macro that does this: 1) for cells in column F that is a) not empty & b) greater than 3000000, search thru column K for the first empty cell. If there is, a message box to be shown for the cell address. Then the whole macro should stop. Thanks, Dolphin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Find first empty cell in column | Excel Worksheet Functions | |||
find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
find last none empty cell | Excel Discussion (Misc queries) | |||
Find an empty cell and put a dash in it? | Excel Worksheet Functions | |||
Find a empty cell in next column | Excel Discussion (Misc queries) |