ExcelBanter - Excel VBA Test For Blank Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel VBA Test For Blank Cell (https://www.excelbanter.com/excel-programming/305384-re-excel-vba-test-blank-cell.html)

Andoni[_12_]

Excel VBA Test For Blank Cell

Try this, rather than isBlank:

With Range("CNT")
If IsEmpty(.Value) Then .Offset(0, 5).Select
End Wit

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 02:24 PM.