John,
I'm glad I got your attention, you helped me with (Copy specific data
over...), I was able to paste the rows into Sheet2 using your code and a
command button. I'm very grateful.
I've been trying to paste data from a table in Sheet1, below the heading
"Attribute". I've spent all this day in my work, looking at various messages
covering arrays and ranges, is there any way you can help with this?
I think it needs to do the following:
For each cell in worksheet
If cell value="Attribute"
Concatenate cells below, until blank cell is reached and copy contents to
Sheet 2, Column 4, Row 2
Next cell -> if cell value ="Attribute" copy to Sheet 2, Column 4, Row 3 and
so on.
PS I tried to add a RefEdit control, but it went wacko. I'll need to look
into it some more. I would probably use a tool that:
Takes the selected range, concatenates the contents, and pastes the value
into a selected cell in Sheet2.
"John Bundy" <Xjmbundy1@gmailX.com remove X''s> wrote in message
news:F988294F-417A-4BC5-B536-FCFC65D1DEFB@microsoft.com...
Do you mean putting a userform in the middle of you program with a RefEdit
control? Try it out, insert userform and put a refedit control on and at the
point in the code you need it type Userform1.show. Post any other questions
you have from there.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"dd" wrote:
> It would be cool if I could record a macro and then edit out the selected
> cells and replace with some code to make the select range dialog box to
> appear, and when I have made the selection the macro resumes with my
> selection?
>
> Dylan Dawson
> Scotland
>
>
>