Thread: Using IF, Then with rowsource?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAA[_23_] CAA[_23_] is offline
external usenet poster
  
Posts: 1
Default Using IF, Then with rowsource?
Does anybody know why i can't do this

If ShN 4 And ShN < 9 Then
shHeight1.Enabled = False
shHeight1.BackColor = &HA49597
ShHang1.RowSource = "Sheet1!B50:B56"
Else
shHeight1.Enabled = False
shHeight1.BackColor = &HF9F8EC
ShHang1.RowSource = Sheets("Window Styles").Range("C50:C57")
End If

Hope somebody can shed some light for me.
Thanks
CA

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

Reply With QuoteReply With Quote