LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ray Ray is offline
external usenet poster
 
Posts: 267
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill option Thana New Users to Excel 2 March 9th 06 06:13 PM
I have a list of data, fill in the gaps. FILL function won't work Triv Excel Discussion (Misc queries) 1 September 17th 05 02:33 PM
Fill Effects on Fill Color Rugdoody Excel Discussion (Misc queries) 1 September 14th 05 06:45 PM
Fill handle formula neeraj Excel Worksheet Functions 9 September 13th 05 01:46 AM
How to fill colour in Excel, it appers No fill in my computer? bede Excel Discussion (Misc queries) 1 June 11th 05 03:27 AM


All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"