View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohanF JohanF is offline
external usenet poster
 
Posts: 1
Default Reference to worksheet range in R1C1


Hi,

This is a stupid question or at least, I'm sure it must have a simpl
answer, yet I cannot find it in the help files:

A want to reference a worksheet range from Visual Basic and load
listbox with it. The records in the range varies and I don't want t
load the blank lines at the bottom of the range into the listbox.

Thanx for any help

--
Johan
-----------------------------------------------------------------------
JohanF's Profile: http://www.excelforum.com/member.php...fo&userid=3377
View this thread: http://www.excelforum.com/showthread.php?threadid=53551