Dont know cellformat in vba
I got a sheet where i have to fint cells i column d that is empety. When i
try vith null, 0, "" not working. Its some strange format that ia dont know. If i try to delite all formats its no help. Anyone who has a advise? |
Dont know cellformat in vba
You don't say what you want to do when you find an empty cell but this may
get you started Sub sonic() lastrow = Cells(Rows.Count, "D").End(xlUp).Row Set myrange = Range("D1:D" & lastrow) For Each c In myrange If IsEmpty(c) Then MsgBox c.Address & " Is empty" End If Next End Sub Mike "osinglad" wrote: I got a sheet where i have to fint cells i column d that is empety. When i try vith null, 0, "" not working. Its some strange format that ia dont know. If i try to delite all formats its no help. Anyone who has a advise? |
All times are GMT +1. The time now is 06:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com