Thread: Excel formula in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Excel formula in VBA
Maybe

myvalue = WorksheetFunction.Sum(Range("a1:a3"))

Mike

"bgkgmg" wrote:

How would I enter the Excel fromula SUM(A1,A3) into a macro. I am getting
confused on the different methods ie, R1C1 etc.

Thanks
Reply With QuoteReply With Quote