Posted to microsoft.public.excel.programming

MaxRott[_3_] MaxRott[_3_] is offline

external usenet poster

Posts: 1

reference sheets

I am using a listbox in sheet2, I want to refernce a range in sheet1,
have the following statement:

Private Sub ListBox1_Click()

ListBox1.ListFillRange = Worksheets("Sheet1").Range("A4:A14").Address

End Sub

For some reason it is not showing any values. Anyone know why?
Thanks

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Reference Sheets in a Vlookup	Thomas Roos	Excel Worksheet Functions	4	November 13th 08 06:40 PM
Reference sheets	KKcags	Excel Worksheet Functions	1	May 7th 08 09:20 PM
Cross Reference between sheets	JP	Excel Worksheet Functions	2	May 14th 06 01:36 PM
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet?	Daniel	Excel Worksheet Functions	1	July 6th 05 09:57 PM
reference sheets	MaxRott[_2_]	Excel Programming	0	December 12th 03 08:09 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us