Posted to microsoft.public.excel.programming

blisspikle[_2_] blisspikle[_2_] is offline

external usenet poster

Posts: 3

Using Validation.Type on a Range

I can do the following...
If Selection.Validation.Type = xlValidateList Then
Else
End If

Why can't I use...

If Worksheets(1).Cells(7,1).Validation.Type = xlValidateList Then
Else
End If

I am using Office 2003

Thanks,

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
Field Validation for Length & Character Type	Rob	Excel Discussion (Misc queries)	3	September 20th 07 01:11 PM
Data validation list type	hshayhorn	Excel Programming	2	September 19th 07 09:29 PM
Data Validation type query	[email protected]	Excel Programming	2	March 7th 07 03:20 PM
Type mismatch using rnge as Range with Type 8 Input Box	STEVE BELL	Excel Programming	11	December 3rd 05 05:02 AM
Drop Down Menu (non Data Validation type)	blc[_2_]	Excel Programming	1	January 20th 04 12:31 AM

All times are GMT +1. The time now is 01:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us