View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brett Brett is offline
external usenet poster
 
Posts: 113
Default ComboBox generic reference

I have a series of comboboxes in a sheet (REFI1, REFI23 etc). How can I make
the second line of code generic (i.e pass the value of rw into Me.REFI & rw)?
Dim rw As Long: rw = 51
Range("AG" & rw) = Me.REFI51

I tried:
Range("AG" & rw) = Me.REFI & rw
but it debugs with "REFI" data member not found.
Thanks in advance, Brett.