Functions in Excel and Access 1

[RAClarke]

I have two function based question, if anyone can help?

(1) Is there a function which you can use to make a cell equal the value of another cell, rather than the formula behind it? (eg if A3 =A1+A2, putting '=A3' into cell B1 will effectively make B1 =A1+A2 as well, so if A1 changes at some time - during a macro run for example - B1 will change too. I want B1 to take and retain the original value.)

(2) Is there a list of functions in Access equivalent to the list in the Function Painter in Excel?

Thanks

 

[DaleWatson123321]

Hi RAClarke,

Simple solution, but you NEED to INCLUDE the following code in your macro (i.e. INSTEAD of using a "live" formula in B1.

Sub Update_B1()
Range("B1&quot.Value = Range("A3&quot.Value
End Sub

Hope this helps. Please advise.

Regards, Dale Watson dwatson@bsi.gov.mb.ca

 

[RAClarke]

That's great! Thanks for your assistance with this!