how to display cell value in formula
if you want to do it with code, you'll have to break your formula down
something like this:
sub test
Range("c1").Formula = "=" & Range("A1").Value & "*" & Range("b1").Value & ""
end sub
--
Gary
"harshu444" wrote in message
...
hi guys,
my problem is this, a1 is 5, b1 is 6, c1= a1*b1, how can i
display the cell value as 5*6.
PLZ HELP
|