Comments by Faisal faisal from Vsevolozhsk

Faisal faisal from Vsevolozhsk 23-Jan-24 4:08am View

I try everything:(, but no solution unit now
have notice that the code is working very well when I clicking only in cells but if I have clicked on pictures, buttons, any object (non cell) and then run the code it will shows this error.

Faisal faisal from Vsevolozhsk 23-Jan-24 4:07am View

I try this but the same problem happen, I have notice that the code is working very well when I clicking only in cells but if I have clicked on pictures, buttons, any object (non cell) and then run the code it will shows this error.

Faisal faisal from Vsevolozhsk 22-Jan-24 13:09pm View

I have use the debugger and it shows the error in these two:

.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=Join(Application.Transpose(valuesArray), ",")

Comments by Faisal faisal from Vsevolozhsk (Top 3 by date)