change active cell in excel; i know I can press Cntrl G and enter the cell to go to. To make it easier, I would like a button which could be clicked and have the spreadsheet automatically move to a different cell
Any ideas would be appreciated
I used the folowing code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'simple example of
' dynamically positioning chart and
' assigning values to a single series chart
'you must have a defined range of series names
' and a defined range for the columns containing the...