Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: how to convert "27.11.2007 15:13" to number (cellformat fai | Excel Discussion (Misc queries) | |||
CellFormat is lost when using CopyFromRecordset | Excel Programming | |||
I dont want #N/A! | Excel Discussion (Misc queries) | |||
Excel 2003 cellformat efter makrokörning | Excel Discussion (Misc queries) | |||
Save Cellformat in a variable | Excel Discussion (Misc queries) |