Application.Goto Reference gets error 1004
On Dec 25, 9:04*am, Chip Pearson wrote:
Try
Application.Goto Range("AccountAbbreviations"),True
Cordially,
Chip Pearson
Microsoft MVP
* *ExcelProduct Group
Pearson Software Consulting, LLCwww.cpearson.com
(email on web site)
On Wed, 24 Dec 2008 21:06:00 -0800, cellist
wrote:
I get "Run-time error 1004,Referenceisnotvalid" when I execute
Application.GotoReference:="AccountAbbreviation s"
* *Selection.ClearContents
The name "AccountAbbreviations" is, in fact,notdefined. How can I check
fornotdefined so that the code can continue?
TIA,
Phil- Hide quoted text -
- Show quoted text -
thanks Chip.
|