Hi, I need to print 5 different named range areas dependent on a cell value
Sheet name 'Navigator', cell B9
If B9 = 1 print 'Arab1'
If B9 = 2 print 'Arab1' & 'Arab2'
If B9 = 3 print 'Arab1' & 'Arab2' & 'Arab3'
If B9 = 4 print 'Arab1' & 'Arab2' & 'Arab3' & 'Arab4'
If B10 = 5 print 'Arab1' & 'Arab2' & 'Arab3' & 'Arab4' & 'Arab5'
I want the print button to appear on Sheet 'Arable Margin'
Hope you have enough information - any help appreciated