By my interpretation of the questions:

A#1

ActiveSheet.Cells(10, 10) = WorksheetFunction.Sum(Range("ColA")) _
+
WorksheetFunction,Sum(Range("ColB"))

A#2

Is not logica if ColB is a name for a range of cells, it would generate and
error because it would be attempting to use an Object as a variable in one
case, or attempting to make several cells equal to a single value, which
would also throw an error A named range is nothing more than a string
variable for a range address. Therefore, it must be used in the same manner
as a range address..


"ekareem" wrote in message
...
Hi,
I have 2 columns, let's say A and B and I named them ColA and ColB
correspondingly.
I want to be able to write something like this:

Question #1:
Cell (10,10) = ColA+ColB

Question #2
ColB = ColA+1

Could some one provide the syntax for each of the above please?

Thank you much
ekareem