Sorry, I din't see the mail.. I hope it worked well..
Thanks Ricardo..
On Sun, Jan 26, 2014 at 10:10 PM, Rob Flott wrote:
> Ricardo,
>
> Thank you very much, I really appreciate your help.
>
> Rob
>
> On Fri, Jan 24, 2014 at 7:15 PM, Ricardo® wrote:
>
>> Hi Rob,
>> To solve the problem of er
Ricardo,
Thank you very much, I really appreciate your help.
Rob
On Fri, Jan 24, 2014 at 7:15 PM, Ricardo® wrote:
> Hi Rob,
> To solve the problem of error, you can delete this (
> Sheets("List3").Select ), it will not affect the main macro.
>
> Basole
>
>
>
>
> 2014/1/24 Rob Flott
>
>> Anoo
Hi Rob,
To solve the problem of error, you can delete this ( Sheets("List3").Select
), it will not affect the main macro.
Basole
2014/1/24 Rob Flott
> Anoop,
>
> When I opened the file I got run time error '57121'
> "Application-defined or object-defined error"
> And when I clicked Debug it
Anoop,
When I opened the file I got run time error '57121'
"Application-defined or object-defined error"
And when I clicked Debug it took me to the Sub Workbook Open() and
highlighted the line Sheets.("List").select
Any ideas as to why I'd get that error message?
Thank you for your help with thi
Hi Rob,
Please have look at attached one...
On Thu, Jan 23, 2014 at 6:48 AM, Rob Flott wrote:
>
>
> On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote:
>>
>> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
>> names. This range will vary, and I have a Na
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote:
>
> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
> names. This range will vary, and I have a Named Cell that identifies the
> range. For example the range of names in one example is A3:A8. But in
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote:
>
> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
> names. This range will vary, and I have a Named Cell that identifies the
> range. For example the range of names in one example is A3:A8. But in