Thread: Designated a cell as a name range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fastbike Fastbike is offline
external usenet poster
  
Posts: 1
Default Designated a cell as a name range

Can I designate the cell that I am is a "named range"?
For exmample:

Range("A1").Select
Cells.Find(What:="Involuntary Termination Count"
MatchCase:=True).Select
Selection.ClearContents
Selection.Offset(1, 0).Select

How do I program VBA to name the active cell I am in?

(I need to program this way as Involuntary Termination Count keep
moving depending on the pivot table report generated.

Thanks

--
Fastbik
-----------------------------------------------------------------------
Fastbike's Profile: http://www.excelforum.com/member.php...fo&userid=2670
View this thread: http://www.excelforum.com/showthread.php?threadid=40031

Reply With QuoteReply With Quote