Thread: Extracting formula instead of result from cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
lithium81[_4_] lithium81[_4_] is offline
external usenet poster
  
Posts: 1
Default Extracting formula instead of result from cell

Hi,

Is it possible to get the forumla from a cell instead of a the result
of the forumla using VBA/Macros?

e.g. In cell A1 I have the formula B1+C1.

I want to retrieve this formula and furthermore it wud be great if I
could get the values in B1 and C1, but I think once the formula can be
extracted, the rest will be easy.

Thanks!!


--
lithium81
------------------------------------------------------------------------
lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461
View this thread: http://www.excelforum.com/showthread...hreadid=494029

Reply With QuoteReply With Quote