Macro to insert this formula automatically on start up
Hi Sunny,
Try assigning the following code to a button from the Forms toolbar:
Public Sub Tester()
ActiveSheet.UsedRange.Formula = "=Sheet3!A1&"""""
End Sub
---
Regards,
Norman
wrote in message
ups.com...
I need an excel sheet to automatically run a macro on click command, so
that this formula
=Sheet3!A1&""
is inserted in all cells in the worksheet.
Please advise on how i can go about doing this.
Cheers!
Sunny
|