Yes, its working for me,
can you please share the screenshot.
thanks
--
On Sat, Aug 27, 2016 at 10:48 PM, Manju Keerthi
wrote:
> Was it working fine for you? i am getting error in the below two line
> (error #1044) so, Else part "Range("b2").Validation.Delete" is not
> working.
>
> .Add Type:
Was it working fine for you? i am getting error in the below two line
(error #1044) so, Else part "Range("b2").Validation.Delete" is not working.
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween,
Formula1:="=OFFSET(Sheet1!$A$2,,,COUNTA(Sheet1!$A$2:$A$100))"
Try enclosed one.
--
On Sat, Aug 27, 2016 at 10:01 PM, Manju Keerthi
wrote:
> Thank you so much. This helped me a lot:-)
>
> Is there any option to disappear the dropdown when user does not have any
> value in column B. instead of disable the drop down in the column B.
>
> once again Thanks a l
