[dba-Tech] Refer to an Excel formula

I've got it now. It's brain-dead simple. Good thing, since I'm brain-dead.

Dim sFormula as String
sFormula = Range("A1").Formula

Doh!
Arthur

On 8/10/07, Jim Lawrence <accessd at shaw.ca> wrote:
>
> Hi Arthur:
>
> Would you not just go into Tools > Macro > Visual Basic Editor create any
> function and then call that function from the cell?
>
> Jim
>
> -----Original Message-----
> From: dba-tech-bounces at databaseadvisors.com
> [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
> Sent: Friday, August 10, 2007 7:22 AM
> To: Discussion of Hardware and Software issues
> Subject: [dba-Tech] Refer to an Excel formula
>
> I want to grab a formula from an Excel cell and then parse it. What's the
> syntax to grab the formula as text so I can then extract part of it using
> the standard text functions?
>
> TIA,
> Arthur
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>