View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kittronald kittronald is offline
external usenet poster
 
Posts: 162
Default Changing function name in formula

Isabelle,

Thanks for the response and understanding what I was trying to
accomplish.

For calculating one cell, your solution works.

Is there a way to modify it so that I can Fill Down or Fill Right.

For example, if I were to fill right ...

=EvaluateString($B$1&"(A1:A2)")

it should look like ...

=EvaluateString($B$1&"(B1:B2)").


- Ronald K.