Thread: Range naming
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
 
Posts: 473
Default Range naming

BigJim wrote:
Thanks. My problem is with the syntax of the
"rSource = " line below.


Putting Set in front of rSrc would be helpful.
That's why it will be saying "Object variable not Set" to you.
You always have to use Set when making an object variable refer to a
particular object, as here.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup