![]() |
#1
|
|||
|
|||
![]()
Hi,
I've been struggling with this for a while now, so i realllyyyy hope someone can help! I have this code Private Sub CheckBox1_Click() If OptionButton1.Value = True Then Sheets("Sheet1").Select Range("J4:J40").Select Selection.FormulaArray = "=IFERROR(INDEX(C$2:C$14, SMALL(IF($B$2:$B$14=1, ROW($B$2:$B$14)-1),ROWS(G$2:G2))),"")" Selection.Columns.AutoFit ElseIf OptionButton1.Value = False Then Range("J4:J40").Value = " " End If End Sub Where I'm trying to get the formula perforned in cell J4. It just wont do it! And I dont really get why! Please Help |
Tags |
check box, iferror, index |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Applying styles dynamically? | arkofcovenant | Mail Merge | 1 | 05-08-2015 06:02 AM |
applying a style in a new document | lihin | Word | 1 | 12-13-2012 05:22 AM |
![]() |
chloe.eloise | Word | 2 | 05-16-2011 12:13 AM |
Help applying different margins to different pages | kthomp | Word | 0 | 06-18-2010 11:37 AM |
Applying And Removing Letterhead | skoz55 | Word | 0 | 08-06-2009 10:22 PM |