Macro to copy all rows between Comments

M

Mrs. Robinson

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?
 
D

Don Guillett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify Macro to Include Inserted Rows 3
Macro for hiding/unhiding a set of rows 3
Code to add comments to selected cells within a selected range 30
Combine 2 columns in a dynamic range into one 7
Copy yellow shaded rows to another worksheet 2
5 months prior to date macro help please 13
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro does not delete all the required rows 3

Top