Thread: Create formulas with $Rn1Cn2:$Rn1Cn3 format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael D. Ober[_2_] Michael D. Ober[_2_] is offline
external usenet poster
  
Posts: 13
Default Create formulas with $Rn1Cn2:$Rn1Cn3 format
I need to have VBA create formulas with mixed referencing such as:

=SUM($G10:$G20)

I can create =SUM($G$10:$G$20) and =SUM(G10:G20), neither of which is what I
need.

Thanks,
Mike.


Reply With QuoteReply With Quote