Posted to microsoft.public.excel.programming

ExcelMonkey[_190_] ExcelMonkey[_190_] is offline

external usenet poster

Posts: 172

Isblank Function not working in VBA

I have a For Each loop that loops thru cells in a
worksheet. I am trying use the isblank function from
Excel on it. Howevere I am getting an Run time error 438
saying Object does not support this property or method.
Why is this?

If UserForm1.IgnoreBlanksBttn = True And _
Application.WorksheetFunction.Isblank
(cell) = True Then 'New

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ISBLANK function not working when cell is blank dut to function re	mcmilja	Excel Discussion (Misc queries)	9	May 7th 23 03:43 AM
ISBLANK and OR Function	Jacob Skaria	Excel Worksheet Functions	0	June 17th 09 08:01 AM
ISBLANK() function	George	New Users to Excel	1	July 14th 06 08:40 AM
isblank function	Brian	Excel Worksheet Functions	8	December 12th 04 01:35 PM
ISBLANK function	keyt	Excel Programming	2	October 10th 03 08:24 PM

All times are GMT +1. The time now is 09:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us