pete_the_greek
New Member
- Joined
- Jun 6, 2008
- Messages
- 1
Hey all, should be an easy one for everyone this but i'm stumped.
I basically want to put the formula on the second line below into a cell, but when it runs it does'nt put it in the cell, just leaves it blank.
currentcontents = Range("D5").Value
Range("D1").Formula = "=Data!$C$31*" & currentcontents
Many Thanks, Pete
I basically want to put the formula on the second line below into a cell, but when it runs it does'nt put it in the cell, just leaves it blank.
currentcontents = Range("D5").Value
Range("D1").Formula = "=Data!$C$31*" & currentcontents
Many Thanks, Pete