View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] Qull666@hotmail.com is offline
external usenet poster
 
Posts: 114
Default Is it possible to create a dynamic range in CONTROL TOOLBOX (form)

Is it possible to create a dynamic range in CONTROL TOOLBOX (form).

I have tried this:

1) in the ListFillRange: Listing (refer 2)

2) Name Range:
Called: Listing
Syntax: =offset(Sheet1!$E$2,0,0,CountA(Sheet1!$E:E),1)

But somehow the form doesn't pick up the new data in the name range.

Is there a way to automate this?

Thanks.