Printable View
I have a spreadsheet that I am forced to keep 100 rows and 130 columns. For ease of use, I want to use a command button that will automatically pan from one cell to another specified cell location.
I am extremely rusty with VB, what kind of operators and code will I need to use so the command button automatically pan the view from cell A4 to cell Q3 for example?
Is this an excel file? If so you will need to use the microsoft.office.interop.excel dll in your project.
Also, I'm sure there is a cell.select method that will essentially highlight it and bring it to focus.
Justin
The file is an Excel 2007 file.
I have attempted to use 'goto' statements, but think that may only be applicable as an error function.