Command Help

[Nick C]

Hi a newbie to vba,have understanding of program design but not off command
for use with vba.

I currently trying to do a simple project with a table

Can some one assist me with a web site or commands to help me achieve the
following

read two cells out of a row in a table

put the values and do a calculation (cell 1 value * cell 2 value)

and put the result in the same row last cell

then the best way of creating a loop to do this for each existing row.

many thanks

Devo

 

[Steve Yandl]

Check at http://www.mvps.org/word/FAQs/index.htm
Select the macros and VBA tab and scroll down to the section on tables.

Steve

 

[Nick C]

Thanks for your reply steve...

I had allready tried that site to assist me writiting the code.. but the
bits i need are not there..

any other ideas..

regards

Devo

 

[Word Heretic]

G'day "Nick C" <[email protected]>,

Commercially, as either tutor or developer, yes.

Hi a newbie to vba,have understanding of program design but not off command
for use with vba.

I currently trying to do a simple project with a table

Can some one assist me with a web site or commands to help me achieve the
following

read two cells out of a row in a table

put the values and do a calculation (cell 1 value * cell 2 value)

and put the result in the same row last cell

then the best way of creating a loop to do this for each existing row.

many thanks

Devo

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
wordheretic.com

If my answers r 2 terse, ask again or hassle an MVP,
at least they get recognition for it then.
Lengthy replies offlist require payment.

 

[Steve Yandl]

Do you know how many columns the table contains?
Do you know which columns the two values you want to multiply are in and is
it the same in each row?

 

[Nick C]

Thanks for your reply steve..

Yep

dead simple - 4 colums

1st one name - 2nd nett wages - 3rd one deduction percentage - 4th nett
wages - dedeuction

I think i have got the right way round (in reflect to nett and gross)

Cheers

Nick