Thread: Using a Varible inside of a proper address
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
TerryK[_2_] TerryK[_2_] is offline
external usenet poster
  
Posts: 16
Default Using a Varible inside of a proper address
Try this
ActiveWorkbook.Names.Add Name:="count",
RefersToR1C1:="=" & LogSheet & "!R8C7"

If this does not work you may have to sent the string to a variable first
x= "=" & LogSheet & "!R8C7"
then
ActiveWorkbook.Names.Add Name:="count",
RefersToR1C1:= x

TerryK
Reply With QuoteReply With Quote