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[_10_] Chuckles123[_10_] is offline
external usenet poster
  
Posts: 1
Default Using a Macro to Sum a Variable-Length Range (a Column)

Dave,

Thanks for your help.

I used: Target.FormulaR1C1 = "=SUM(R3C:R[-1]C)",
which is very similar to your suggestion.

A corollary question -- I have a column of numbers (each cell contain
a number), with a fixed starting cell but a variable ending cell.
want the macro to assign a Name (Workbook definition) to this range.
Any ideas?

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