How to Use Tab Names as Variables in Excel. When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window. When you edit the page code, the ...

If you want to use Excel's Goal Seek on multiple cells simultaneously, you'll need a much more powerful tool. Fortunately, one such tool comes with Excel. Let's have a look at the Solver add-in.

To avoid using reserved words and screwing up your code, just decide on a naming scheme for your variables. I've put "my" in front of my example variable, but you'll probably want to come up with ...