Formatting of pasted row via VBA

[HelenW]

Hi all

I have the current code:

Please Login or Register  to view this content.

Where rows are inserted, can I stop them from copying the formatting from the row above??

Also, I would like the text that is pasted into the cell A (for divrow and arearow) to be left aligned and bold.

Can someone help?

[romperstomper]

Try this:

Please Login or Register  to view this content.

[blane245]

As you may know, the format of a cell contains many attributes. Look at the Format->Cells... Excel menu option. When you say that you don't want to copy the format, what do you mean? Do you want to make the format something like another row on the spreadsheet? If that is the case, then you could copy that row to the clipboard and then do a PasteSpecial for format only onto the new row.

Let us know if you need more help.

[HelenW]

That's excellent romperstomper - thank you. One other minor thing I need to solve, however, is that rows 2 and 3 (the newly inserted ones) are coming in as wrapped text as this is the format of the header row. I've tried adding in a small addition to the code but it's not working...

Please Login or Register  to view this content.

(I've just pasted the relevant bit of the code)

[HelenW]

Hi Bob - thanks for your ideas, however I don't want the rows to be formatted the same as any other, necessarily. I just want them to be pasted in as a "normal" row, then make them left aligned and bold which the provided code did fine. I'm stuck with the wraptext now though!

[romperstomper]

The clearformats should remove wraptext anyway. Can you post a sample workbook showing the problem?

[HelenW]

I'll give it a go - lots of data taken out, though, as I don't want it published on a forum - hence the big gaps! You can see what has happened when I've clicked the button on sheet 1 to run the procedures though - both rows at the top still have wrap text applied...

[romperstomper]

Your code never processes rows 1 or 2 though?

[HelenW]

Got it now.... thanks for pointing that out! It wasn't wrap text after all, but just plain old row height :-)

[romperstomper]

Glad it's sorted.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save