Thread: How do I denote values stored in columns in my macro?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default How do I denote values stored in columns in my macro?
Range("K7").Formula = "=C7*I7*.25"

if you want to do the calculation in vba

v = Range("C7").Value * Range("I7").Value * 0.25
Range("K7").Value = v

--
Regards,
Tom Ogilvy


"Greg" wrote in message
...
I need to multiply:
C7*I7*.25
How do I code the values in C7 and I7 into the formula for K7 (the column
I'm writing a macro for?


Reply With QuoteReply With Quote