I have an aplication that sends a report to excel and at the end I know the row and the strtin colum that need a formula like =sum(b3:b99) I need this formula on evry cell on that row end I know how many colums but not the colum letter.
the range property does not take numeric refrences like .range(999,2:999,60) it needs an alpha "A900:AH900" to do a copy, so I copy the first cell with the formula and then pase n times to the right the formla and it works.
now here is the problem. the copt rage still selected so if the user press <
> the formula gets copied to the active cell.
how do i unselect the copy range.
I triend selecting another range, storiing a " " to a cell that i know is empty. etc. etc
please help.
Bernardo
B.D.H.