Hi,
I want to incorporate formulas to different cell on command butto
click. The formula is common for different columns just the position o
the cells value to be used shifts by one column.

To explain, say I have a formula for cell A3 which is A3=A4+A5
Similary, I want to use this formula for the next cells like B3=B4+B
and so on for C,D.

Instead of writing the same formula every time, I want to make thi
dynamic by changing the value of A to B, C and so on.

I tried using Range((Chr(Asc("A") + i)) & iCounter).value by puttin
this stmt in a for loop for i. But, this thing when put in the formul
does not works.

Can anyone suggest a solution to this problem.

Thanks,
Samee

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