Hi,
I wanted to insert some rows in the Excel sheet on a button clic
dynamically, and I wanted the sum of all cells of that row to b
displayed on the last cell. I tried this using Sum(B5:I5) and it work
fine for this. But, I want the same functioniality to be inserte
dynamically based on the number of row that is selected, in such a wa
the row number can be changed from 5 to 6 and so on.
I tried using:
sum((Chr(Asc("A") + 1) & iCounter + 1) : (Chr(Asc("A") + 5) & iCounte
+ 1)). But, this is not working.

I hope that I have made my problem clear enough. Can anyone suggest th
solution to this problem.

Thanks,
Samee

--
Message posted from http://www.ExcelForum.com