Thread: Public Const to refer to a range name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimT TimT is offline
external usenet poster
  
Posts: 69
Default Public Const to refer to a range name
Can this be done??
I'm trying to set this up and I'm having trouble.
Keep getting a compile error: Constant expression required.
________________________________________

Option Explicit

Public Const CDLoc = Range("CDFLoc").Value




Reply With QuoteReply With Quote