View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Use variable in macro coding


MyFormula="Sum("H" & mFrow & ":H" & mLrow & ")"

---
Per

On 17 Jul., 07:42, bmurlidhar wrote:
I want to give sum command *i.e. =SUM(H1:H10) and my variable for
mFrow = 1 and mLrow = 10 how can i use variable in function