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.