vb value to cell possible?

[Guest]

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!!

 

[JulieD]

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

 

[Guest]

sheets("Sheet1").range("A1").value = myVariable

or something like that...