Thread: RowSource Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kieran[_32_] Kieran[_32_] is offline
external usenet poster
  
Posts: 1
Default RowSource Problem
Todd,

It looks like the COUNTA portion of your formula is counting too many
columns.

try

ComboBox6.RowSource = "OFFSET(" & Worksheets(8).Name & "!
AG3,,,COUNTA(" & Worksheets(8).Name & "!AG3:AG100))"


This may still have a problem, as COUNTA counts blanks. IF the cells
are empty hwever it should work.


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

Reply With QuoteReply With Quote