how do i type something in a cell using vba?
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 |
how do i type something in a cell using vba?
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 |
how do i type something in a cell using vba?
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. |
All times are GMT +1. The time now is 03:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com