Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BASIC VBA QUESTION
I am trying to learn visual basic for excel . My first program is to
simply add a column of numbers . The numbers are in column c but I want to put the result of this sum in column A row 10 . This is my program so far but this will only put the total on the cell that is highlighted when I run the macro . Sub test1 Selection . Insert ("=+c4+c5+c7") End Sub Again any help is most appreciated and if someone could point me to a web site for absolute beginners that would be great . Sincerely Mason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BASIC VBA QUESTION
One way:
Option Explicit sub test2() with activesheet .range("a10").formula = "=c4+c5+c7" end with end sub And for your reading pleasure, take a look at David McRitchie's site: http://www.mvps.org/dmcritchie/excel/getstarted.htm MASON wrote: I am trying to learn visual basic for excel . My first program is to simply add a column of numbers . The numbers are in column c but I want to put the result of this sum in column A row 10 . This is my program so far but this will only put the total on the cell that is highlighted when I run the macro . Sub test1 Selection . Insert ("=+c4+c5+c7") End Sub Again any help is most appreciated and if someone could point me to a web site for absolute beginners that would be great . Sincerely Mason -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very basic VBA question. | Excel Discussion (Misc queries) | |||
basic question | New Users to Excel | |||
Basic question...sorry | Excel Worksheet Functions | |||
Basic question | Excel Discussion (Misc queries) | |||
Basic VBA question | Excel Programming |