Put a formula in another cell
Put a formula in another cell
(OP)
Hi,
Is there a way to put a formula (or number) from a formula/function in another cell?
eg. a function in cell A1 produce a formula in cell B1.
Thanks
Is there a way to put a formula (or number) from a formula/function in another cell?
eg. a function in cell A1 produce a formula in cell B1.
Thanks





RE: Put a formula in another cell
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Put a formula in another cell
I want to do that without putting anything in B1.
RE: Put a formula in another cell
Could you clarify what you want to calculate and what you want to see. If you just want to hide something then use Format|Cells|protection and check Hidden and Locked, then Use Format|Cells|Font and set the colour to the same as the cell background
Sorry I seem to be a bit dense today
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Put a formula in another cell
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.AddressLocal = "$A$1" Then
Target.Formula = [B1] * [C1]
End If
End Sub
RE: Put a formula in another cell
RE: Put a formula in another cell
The method I showed utilizing VBA for the equation is a method I use for calculation spreadsheets I sell on the net. Excel is not a "secure" environment.
For normal use - I agree its not worth the trouble.
RE: Put a formula in another cell
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Put a formula in another cell
VBA is tougher to break when protected, where Excel's standard protection scheme at the sheet level can worked around in seconds with programs readily available on the web.
RE: Put a formula in another cell
VBA's vastly improve protection scheme, on the other hand, may require almost an entire minute to bypass.
RE: Put a formula in another cell
RE: Put a formula in another cell
I'm not going to violate the US DMCA by providing any specifics, but bypasses are readily available (just as I assumed they would be). Google it.
To be honest, it looks like it might actually take about 10 minutes (including download time by dial-up).
RE: Put a formula in another cell
RE: Put a formula in another cell
My question was rhetorical - there is no realistic protection in a standard Excel spreadsheet, whether in code or on the sheet. If you want any reasonable level of protection for your intellectual property you need a fully compiled application.
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk