VBA: last_column & fill-down help

[Ray]

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

[Otto Moehrbach]

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
[email protected]. Remove the "nop" from this address. HTH Otto
"Ray" <[email protected]> wrote in message
news:[email protected]...
> 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
>