View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
muster muster is offline
external usenet poster
 
Posts: 25
Default how to get formula content of a cell?

Thank you. What I really want is to reference to the formula in another
cell.

Alan wrote:
Press Ctrl and ` together (key to the left of 1 on the left side of the
keyboard),
Regards,
Alan.

"muster" wrote in message
ups.com...
For example

A1: =b2+c2, result is 5

I'd like to get "=b2+c2", not 5, without VBA.

Thank you.