Posted to microsoft.public.excel.programming

Rich Cooper Rich Cooper is offline

external usenet poster

Posts: 35

ranges

I am working with a range of names, I want to take that range and have a
macro take the first 8 characters of each cell in that range and paste them
into another range. Then i want the macro to go back throught the initail
range and take the next 8 characters and paste that to a second new range
right next to the one with the first 8 characters. If this can be done?
does anyone know how?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
how copy formula that contains ranges so ranges do not overlap	Patty	Excel Worksheet Functions	1	November 20th 08 04:15 PM
Ranges	PAL	Excel Worksheet Functions	2	November 15th 07 12:47 AM
Sum Ranges	FIRSTROUNDKO via OfficeKB.com	Excel Worksheet Functions	1	December 20th 06 04:55 PM
Like 123, allow named ranges, and print named ranges	WP	Excel Discussion (Misc queries)	1	April 8th 05 06:07 PM
Max Value from 2 different Ranges	ibeetb	Excel Programming	1	September 17th 03 03:22 PM

All times are GMT +1. The time now is 09:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us