Option Explicit Sub naechste_leere_Zelle() '************************************************** '* H. Ziplies * '* 11.06.2012 * '* erstellt von HajoZiplies@WEB.de Spam * '* http://Hajo-Excel.de * '************************************************** Dim RaFound As Range ' Spalte A Set RaFound = Range("A1:A" & Rows.Count).Find("", , , xlPart, , xlNext) If Not RaFound Is Nothing Then MsgBox RaFound.Address End If Set RaFound = Nothing End Sub
Option Explicit Sub nachste_leere_nach_oben_Spalte_A() Dim loI As Long For loI = ActiveCell.Row To 1 Step -1 If Cells(loI, 1) = "" Then MsgBox Cells(loI, 1).Address Exit For End If Next loI End Sub
58.4k Fragen
249k Antworten
7k Nutzer