Thread: Cell Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Cell Value

Hi Dodo,

Try:

Range("B1").Value = Range("A1").Value

---
Regards,
Norman


"dodo" wrote in message
...
Hi there,

i am a newbie in excel vba and i made a simple macro but i miss something
there.

it is a macro that selects value of cell "A1" and then paste it in cell
"B1" quite simple ?, but my PROBLEM is that: the cell value "A1" isn't
numbers (it is something like 3+2*2) so when i paste it in "B1" i get the
same result of "A1" while i want to evalute "A1" , so any ideas. THANX.