Posted to microsoft.public.excel.programming

external usenet poster

Posts: 191

ListFillRange

I have the following code in a procdu

Sheets("Home").OLEObjects("ListBox1").ListFillRang e =
Range("wrkshtrng").Address

The listbox window is blank. I have been using:

Sheets("Home").OLEObjects("ListBox1").ListFillRang e = "wrkshtrng"

But I have been having problems. I don't know if that is the cause of the
problems or not. Why is the first code not working?
Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ListFillRange not working	Jeff	Excel Programming	2	July 1st 05 03:36 PM
How to Set ListFillRange to Another Sheet	Chaplain Doug	Excel Programming	3	April 29th 05 01:54 PM
I can't figure out listfillrange	LostinVA	Excel Programming	6	April 15th 05 03:21 PM
ListFillRange	Dave Baranas	Excel Programming	0	August 12th 03 05:09 AM
ListFillRange	Dave Baranas	Excel Programming	1	August 11th 03 11:08 PM

All times are GMT +1. The time now is 03:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us