I have 2 sets of columns - one with values and one with formulas that use values. Formulas are meant to change depending on a certain condition so I want to insert them with VB macro.
For example I want cells in column E to equal cell B- cellA from the same row.
1)how do I explain to vb that I want this formula applied to whole range (i.e. how do I define row number)
2) How do I define column name - in my prog I use column numbers - is there any way to translate column number into column name (1=A, 2=B)