Sc00tty
01-08-2010, 11:12 AM
Hi I posted this on the VB section incorrectly.... If you can please help me.
I am trying to make a bit of code for one of my spreadsheets where when you select an option from a List in Excel (which is a list from a range) it will look up the result and find a Range with the same name and then change a range of cells elsewhere on the Worksheet.
So i am trying to change a range on one worksheet to any one of another ranges defined elsehwere in the spreadsheet dependant on what the user selects from a List.
Any help on this one would be hugely appreciated.
I am trying to make a bit of code for one of my spreadsheets where when you select an option from a List in Excel (which is a list from a range) it will look up the result and find a Range with the same name and then change a range of cells elsewhere on the Worksheet.
So i am trying to change a range on one worksheet to any one of another ranges defined elsehwere in the spreadsheet dependant on what the user selects from a List.
Any help on this one would be hugely appreciated.