Excel Microsoft Bug -Data Population in drop down box

[Raj_singh]

hi ,

In VBA we have a string whose length is greater then 253 (by len() function
in vb)

when I am trying to add this String Value in excel cell as drop down as

With Sheet1
.Range(.Cells(inserDatatRowNo, loc), .Cells(inserDatatRowNo, loc)).Select

With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=StringValue

.IgnoreBlank = True
.InCellDropdown = True
.ShowInput = True
.ShowError = False
End With
End With

It is giving Error-

Run Time Error '-2147417848(800101087)':

Automation Error

The Object invoked has disconnected from its client

and whole application stops working



In case of lenght of string less then 253 code is working fine and data is
comming in dorpdown

In mocrosoft site they have given some solution but it is not working

http://support.microsoft.com/?scid=kb;en-us;319832&spid=2530&sid=361

http://support.microsoft.com/?scid=kb;en-us;254908


Can any one help me how to resolve this problem???