Add Row above...Not Below

[Hood]

I am trying to revise some code. Currently it takes the cell value and concatenates some words with the cell value and inserts a row with the new cell value below. Now I am trying to do the reverse....insert a row with the cell value above it. Would anyone be willing to help revise this code? Thanks!

Please Login or Register  to view this content.

[PCI]

Try

Please Login or Register  to view this content.

[Ochimus]

Please Login or Register  to view this content.

Hope that helps

Ochimus

[Hood]

Thanks, but not quite....

Here's an example:
A1 = Hot Dog
A2 = Pizza
A3 = Apples

I want:
A1 = Just Stuff Hot Dog Other Stuff
A2 = Hot Dog
A3 = Just Stuff Pizza Other Stuff
A4 = Pizza
A5 = Just Stuff Apples Other Stuff
A6 = Apples

So starting from the last row with a cell value, I want to insert a new row above it containing the current cell value and adding "Just Stuff" & "Other Stuff" to the cell value.

Thanks very much for your time and help.

[PCI]

If data is starting at row 1

Please Login or Register  to view this content.

[PCI]

Another shot
Adjust FR to your need

Please Login or Register  to view this content.

[Hood]

It didn't work, but I changed the order of the lines

Please Login or Register  to view this content.

This way it adds a blank row, but the data is overwriting the original row. I would like the new label to be in the newly created row...

Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Ochimus]

Just add the ref to the row you moved to the code I gave you earlier, as shown below?

Please Login or Register  to view this content.

Ochimus