Posted to microsoft.public.excel.programming

Andoni[_12_] Andoni[_12_] is offline

external usenet poster

Posts: 1

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

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
Conditional formatting to test blank text cell	Andyjim	Excel Worksheet Functions	4	January 10th 08 08:45 PM
test for not blank, use value in cell and set as variable	Robert	Excel Discussion (Misc queries)	0	March 24th 05 11:25 PM
Excel VBA Test For Blank Cell	Tod	Excel Programming	0	July 28th 04 09:34 PM
Excel VBA Test For Blank Cell	Esteban404	Excel Programming	0	July 28th 04 09:10 PM
Excel - To test for a Blank Sheet	TKT-Tang	Excel Programming	5	April 1st 04 04:46 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us