VBA - GOTO named range

[sswcharlie]

Excel97 I have a user data input form. Entry of AA etc in Cell A1 Have a named range for 5 different sets of numbers I want to use cell A1, that will change with each set of entries, the cell will show the name of the range I want to select.(AA,or AB, or AC, or AD, or AE) I can then goto , copy paste etc. With VBA goto AB etc is ok But I want to go to the named range that is showing in cell A1. Can cell A1 when the named range entered goto the named range, elsewhere on the same sheet ? Thanks Charlie Harris

[Bob Phillips]

Just use

[vba]

Application.Goto ActiveSheet.Range("A1").Value2
[/vba]