Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up cell content by type and copy to different cell | Excel Worksheet Functions | |||
Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
type MI in cell, have Michigan show in adjacent cell | Excel Discussion (Misc queries) | |||
Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency | Excel Programming | |||
Type into one cell and automatically clear contents in another cell | Excel Programming |