IsBlank or 6 digits required

Posted to microsoft.public.excel.programming

Ron[_6_]

external usenet poster

Posts: 48

IsBlank or 6 digits required

Hi all,

How would I edit this line to allow only a blank cell or 6 digits.

If Len(Range("a1")(i, col).Value) < 6 Then

Thank you for your assistance, Ron

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
How do you change single digits to recognized double digits?	Evil with a K[_2_]	Excel Worksheet Functions	5	April 3rd 23 02:29 PM
VBA write macro change column with 3 number digits to 4 digits the	James C[_2_]	Excel Discussion (Misc queries)	3	January 25th 10 03:12 PM
4 digits required for a number	Sandeep	Excel Worksheet Functions	1	September 9th 08 01:19 AM
Required Field for 7 Numeric digits only	LRay67	Excel Programming	33	May 30th 08 03:22 PM
How to customize number to 10 digits including 2 digits after deci	Carina	Excel Worksheet Functions	3	September 20th 07 02:50 AM

All times are GMT +1. The time now is 12:39 AM.

Menu

About Us