How to get active cell address and value in Excel VBA — Programming Reminders


Your current cell = ActiveCell ActiveCell has properties like Address, Value and Row. To delete a Row, simply use: Rows(Row_to_delete).Delete To check for emptiness, use IsEmpty(your_cell.Value)

via How to get active cell address and value in Excel VBA — Programming Reminders

Advertisements