Copy cells with varying ranges (VBA)

=?Utf-8?B?QkNMaXZlbGw=?=

Guest

Posts: n/a

6th Jun 2007

Hi Everyone-

I need help with code that will copy a ranges of cells from a single column.
the issues that I am running into is that sometimes there are 15 cells that
need to be copied and other times there are 25 cells that need to be copied.
The first and last cell are always the same, but the amount of cells
inbetween changes. The first cell always says "example 1" and the last cell
always says "close example 1". Thank you for any suggestions you can
provide!!!

-Brian

« Using contents of cells as input for variable? | Formating Multiple cells »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to compare and copy ranges of cells	Vanessa	Microsoft Excel Programming	4	17th Jan 2011 10:23 PM
How can I copy big ranges of cells without drag or copy/paste?	Ricardo Julio	Microsoft Excel Misc	3	23rd Mar 2010 02:38 PM
Using macro/vba to copy varying ranges of rows	=?Utf-8?B?QkNMaXZlbGw=?=	Microsoft Excel Misc	3	6th Jun 2007 02:52 PM
Macro question - Selecting varying ranges of cells.	=?Utf-8?B?SmltIE1vYmVyZw==?=	Microsoft Excel Discussion	3	26th Feb 2007 08:43 PM
Naming cells: varying limits to ranges	Joseph M. Newcomer	Microsoft Excel New Users	1	22nd Mar 2004 04:29 AM