Thread: A1 reference style
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default A1 reference style
Hi folks!

Application.Goto Reference:="INDIRECT(R1C1)"

Why won't that accept an A1 reference?

Both of these fail:

Application.Goto Reference:="INDIRECT(A1)"
Application.Goto Reference:="INDIRECT("A1")"

Thanks
Biff


Reply With QuoteReply With Quote