Hello there,

I am working on macros and now i am calculating the value of columns cell by cell based on the previous cells of the corresponding row in that column.Do i have any method where i can attribute a formula to a column like

data in AE=data in AB+data in AC-data in AD ....

so that for every row cell in AE column the corresponding row cells of the other columns are used to calculate the value.

May be this is a minor issue.But i am a newbie and needs some help.

Thanks in Advance,

Shara.

see this can be done with the help of excel also but its little bit complicated

so u may write code in After Edit event of Flex as

grd.textmatrix(row,4)= val(grd.textmatrix(row,2) &"") +val(grd.textmatrix(row,3) &"")

see its just a hint

use componant one's vsflexgrid for such event of grid

try it

Good Luck