title: Sum function in VBA (number and string)
body: <p>Have a problem with summing cells in vba using =sum(number, string) function.</p>
  
  <p>Here is an example, that is working in regular excel: <strong>sum(5, A1)</strong> </p>
  
  <p>But it doesn't work via VBA formula - asking for a number instead of a string. Is there a way to use <strong>=sum(5, A1)</strong> in VBA?</p>