View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default vb value to cell possible?

Hi

assuming we're talking vba within excel ...
and with your variable called myvariable
then
Range("A1").value = myvariable

where A1 is the cell you want to put it in to.
you could further qualify it using the sheet name, e.g.
Sheets("Sheet1").Range("A1").value = myvariable

Hope this helps
Cheers
JulieD

"mgade" wrote in message
...
How do I put a value from a vb variable into an Excel 2000 cell? I have
read
the help file and various forums, but cant get anything but #Value!!