Prev: Macro command not running in excel 2007
Next: Determining the Active Worksheet
From: Mrs. Robinson on 15 Apr 2010 13:34
I have a macro that opens and names a new worksheet, copies & pastes the
header rows and a named range to the new worksheet. I also have a macro that
adds a new line at the cursor and keeps the formatting. I've allowed for
extra lines in the range so that if rows are added, they too will be copied
to the new worksheet. The text in the rows is never the same and the number
of rows is never the same. Now they want only the rows between 2 comments
(including the rows with the comments) copied, instead of the entire range.
Is this possible?
From: Don Guillett on 15 Apr 2010 13:38
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Mrs. Robinson" <MrsRobinson(a)discussions.microsoft.com> wrote in message
news:337C615C-B779-41BF-8254-F9B4C61AC6C1(a)microsoft.com...
>I have a macro that opens and names a new worksheet, copies & pastes the
> header rows and a named range to the new worksheet. I also have a macro
> that
> adds a new line at the cursor and keeps the formatting. I've allowed for
> extra lines in the range so that if rows are added, they too will be
> copied
> to the new worksheet. The text in the rows is never the same and the
> number
> of rows is never the same. Now they want only the rows between 2 comments
> (including the rows with the comments) copied, instead of the entire
> range.
> Is this possible?

 | 
Pages: 1
Prev: Macro command not running in excel 2007
Next: Determining the Active Worksheet