Dynamic Arrays and Formulae
 

This is going to sound really cheeky but how do I programmatically ge
the $ symbols out of the formula?

cheer

--
Josep

-----------------------------------------------------------------------
Joseph's Profile: http://www.excelforum.com/member.php...nfo&userid=563
View this thread: http://www.excelforum.com/showthread.php?threadid=31387

Dynamic Arrays and Formulae
 

Hi
have a look at the convertformula method in the VBA help

"Joseph" wrote:


This is going to sound really cheeky but how do I programmatically get
the $ symbols out of the formula?

cheers


--
Joseph


------------------------------------------------------------------------
Joseph's Profile: http://www.excelforum.com/member.php...fo&userid=5637
View this thread: http://www.excelforum.com/showthread...hreadid=313874