Posted to microsoft.public.excel.programming

Brad

external usenet poster

Posts: 846

Ranges vs cells with VBA

If I delete each cell in a range manually - I do not get hung up in the
below "if statement". If try to "clearcontents" to the entire range - it
doesn't recognize the isEmpty(Target.value) (I believe). What options do I
have...

If Target.Column = 2 And Not IsDate(Target.Value) And Not
IsEmpty(Target.Value) Then
MsgBox ("Inputs have to be dates")
Target.ClearContents
End If

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
Coping ranges of cells	David	Excel Programming	4	July 2nd 07 07:12 AM
ADD DIFFERENT RANGES OF CELLS	Add non continuous ranges of cells	Excel Discussion (Misc queries)	4	June 27th 06 01:15 AM
specifying ranges using cells	Mitch	Excel Programming	1	June 17th 05 10:13 PM
empty cells in ranges	UniDave	Excel Discussion (Misc queries)	2	November 26th 04 02:18 AM
Special Ranges of Cells	BOHICA	Excel Programming	2	December 12th 03 12:05 PM

All times are GMT +1. The time now is 09:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us