View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shilps Shilps is offline
external usenet poster
 
Posts: 36
Default Please help with AddItem method

Hi
I have posted this query before but got no response that would solve my proble
I have a code as below which when I run gives "Run-Time Error 70: Permission Denied" while it is working fine with other comboxes
read3 =
While Worksheets("QUERY_BUILDER").Range("AR" + CStr(read3)).Value < Empt
Worksheets("QUERY_BUILDER").ComboBox6.AddItem CStr(Worksheets("QUERY_BUILDER").Range("AR" + CStr(read3)).Value
read3 = read3 +
Wen
Whenever I run this code it gives "Run-Time error" Permission Denied
This code is working for other comboboxes
Please tell me why is this behaving this way and what should I do
TIH