using arithmetic operations to fill in data in the cells of an entire column

[shara]

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.

[vijaydiwakar]

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

[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

Hello Vijay,

Thanks for responding.But i dont have a hint of idea about what you told like flex grid.Can you kindly give me the approach with VB macros?

Thanks,
Shara.