LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Last needed info (validation)


Here is the code with the missing link!
What I want to do is activate a validation list (Named "Comply") in
every cell to the right of a cell containing "I" in the B column...

Anyone knows what goes in the (...)?


Dim cell As Range
For Each cell In Range("B:B")
If cell = "I" Then cell.Offset(0, 1).(....)
Next


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=554638

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Some Help Needed on getting info out of a cell from a formula LowRider New Users to Excel 9 December 3rd 07 03:42 AM
varying validation info based on preceding info georgejl Excel Discussion (Misc queries) 1 November 9th 06 10:31 PM
Hyperlink info & help needed John87111 Excel Discussion (Misc queries) 0 April 26th 05 08:58 PM
Info needed...please help! joe smith Excel Discussion (Misc queries) 1 March 22nd 05 02:43 PM
Hey Frank,info needed sameer27p[_15_] Excel Programming 4 July 21st 04 10:03 PM


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"