View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ekareem ekareem is offline
external usenet poster
 
Posts: 8
Default Using Named Columns in a formula within a VBA Macro

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