Soldato
- Joined
- 1 Sep 2005
- Posts
- 10,001
- Location
- Scottish Highlands
Right, im tryign to go way over the top fancy with an excel document. I've got option buttons next to a set of rows in Excel. When i select option button 1, I want it to highlight row4 from C4 to M4. When i click on option button 2, I want it to highlight row5 from C5 to M5 etc etc. I've sort of managed to get it to work, but it's only highlighting C4, C5 and not the rest of the row, despite having it set to "=$B$6:$M$6". Any ideas why this isn't working?
And another question. If you have a complex worksheet like this. What would be the best way to get the data on to the web, including the option buttons and calculations etc?
And another question. If you have a complex worksheet like this. What would be the best way to get the data on to the web, including the option buttons and calculations etc?