I have a form that pastes data into a worksheet. I have informatio
about half way down the page. How do I shift that data down so tha
new information coming in from my text box can be placed between th
top and that other data.

Right now my code just starts pasting after the heading that is in th
middle of the page.

With Worksheets("Notes")
cLastRow = .Cells(Rows.Count, "G").End(xlUp).Row

.Cells(cLastRow + 2, "G").Value = "Top Number: " & TopNum.Text
.Cells(cLastRow + 3, "G").Value = "Part Number: " & LPartNum.Text
.Cells(cLastRow + 4, "G").Value = LNotes_Box.Text

Any Suggestion?

Thank you,
Morr

--
Message posted from http://www.ExcelForum.com