Thread: Using a Macro to Sum a Variable-Length Range (a Column)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuckles123[_15_] Chuckles123[_15_] is offline
external usenet poster
  
Posts: 1
Default Using a Macro to Sum a Variable-Length Range (a Column)

To me, this appears to be more straightforward:

'TO NAME A VARIABLE-LENGTH RANGE STARTING FROM A FIXED CELL -- F1)
(ACTIVE CELL IS MOOT)
Set TopCell = Range("F1")
Range(TopCell, TopCell.End(xlDown)).Name = "TEST1"


'TO NAME A SINGLE CELL (the ACTIVE CELL)
Range("G1").Select
Set TopCell = ActiveCell
Range(TopCell, TopCell).Name = "TEST2"

Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=26581

Reply With QuoteReply With Quote