VBA: last_column & fill-down help
 

Hello -

I've been searching this forum for help and while I've found
bits/pieces of
useful code, I'm not sure how to put it all together. Here's what I
need to
do:
** find last column with data
** delete two columns, one column from the end
- Ex if sheet has 10columns, delete #8 & 9
** in the first blank column, insert fomula (starting 4th row down) and
autofill to last row AND THEN one more row
** then total the values in two columns
- Ex if sheet has 10col, total #6 & 7
** copy/paste_values the inserted formulas

Can you please help me build this code?

Thanks!
Ray

last_column & fill-down help
 

Ray
I'll help you with it but I'm not clear on what you want. If you wish,
send me your file or an example of your file. Include a step by step of
what you want. Actual examples would be most useful. My email address is
. Remove the "nop" from this address. HTH Otto
"Ray" wrote in message
oups.com...
Hello -

I've been searching this forum for help and while I've found
bits/pieces of
useful code, I'm not sure how to put it all together. Here's what I
need to
do:
** find last column with data
** delete two columns, one column from the end
- Ex if sheet has 10columns, delete #8 & 9
** in the first blank column, insert fomula (starting 4th row down) and
autofill to last row AND THEN one more row
** then total the values in two columns
- Ex if sheet has 10col, total #6 & 7
** copy/paste_values the inserted formulas

Can you please help me build this code?

Thanks!
Ray