Phil_Evans
New Member
- Joined
- Oct 30, 2002
- Messages
- 2
Hi,
I'm trying to create a enter a formula into a cell as part of a VBA macro.
The tricky part seems to be that I want part of the formula to refer to a cell on a new sheet. The name of the new sheet is a variable ...Thats where it stops working...
This is what I have;
Cells(x,y)= "=" & new_sheet_name & "!a1*45"
Any ideas?
Cheers, Phil
I'm trying to create a enter a formula into a cell as part of a VBA macro.
The tricky part seems to be that I want part of the formula to refer to a cell on a new sheet. The name of the new sheet is a variable ...Thats where it stops working...
This is what I have;
Cells(x,y)= "=" & new_sheet_name & "!a1*45"
Any ideas?
Cheers, Phil