View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
salgud salgud is offline
external usenet poster
 
Posts: 219
Default 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.