By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,097 Members | 1,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,097 IT Pros & Developers. It's quick & easy.

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

P: 28
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.
Mar 22 '07 #1
Share this Question
Share on Google+
2 Replies


vijaydiwakar
100+
P: 579
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
Mar 22 '07 #2

P: 28
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.
Mar 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.