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
On 10 Jul., 22:44, Giorgio <> wrote: > 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
On Thu, 10 Jul 2008 13:44:04 -0700, Giorgio wrote: > 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.
