PDA

View Full Version : VBA - GOTO named range



sswcharlie
02-28-2010, 10:59 PM
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
03-01-2010, 01:22 AM
Just use



Application.Goto ActiveSheet.Range("A1").Value2