how do i type something in a cell using vba?

[Giorgio]

in a vba code, i use worksheets.()value... to attribute a value to a
variable. is that correct? and how do i actually print something a variable
contains, like eg sum=123 and i want to print 123 in cell A3 in worksheet Raw
of workbook 1.xls. funnily, i cannot get this answer in simple help of
office. a rookie in vba, i must admit! thanks

 

[Per Jessen]

in a vba code, i use worksheets.()value... to attribute a value to a
variable. is that correct? and how do i actually print something a variable
contains, like eg sum=123 and i want to print 123 in cell A3 in worksheet Raw
of workbook 1.xls. funnily, i cannot get this answer in simple help of
office. a rookie in vba, i must admit! thanks

Hi

Sum = 123
Worksheets("Raw").Range("A3") = Sum

Reards,
Per

 

[salgud]

in a vba code, i use worksheets.()value... to attribute a value to a
variable. is that correct? and how do i actually print something a variable
contains, like eg sum=123 and i want to print 123 in cell A3 in worksheet Raw
of workbook 1.xls. funnily, i cannot get this answer in simple help of
office. a rookie in vba, i must admit! thanks

simplest way is something like:
activesheet.range.("A3") = sum
Substitute the real spreadsheet name for "activesheet".
There are lot of other ways to do this, depending on the context.
Hope this helps in your world.