Move text after delete

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

I have a range on my worksheet (B7:K23) that I add and remove data from via
a user form. When I clear contents of data how can I get all data below the
original data to move up a row so as I don't end up with empty cells.

Cheers
Greg
 
Thanks for the reply. I don't want to delete any rows. I just want any text
underneath the cells that I have cleared the contents of to move up 1 row.

Cheers
Greg
 
The code I gave, does not delete any rows.
Unless you have defined names to those cells the effect is exactly same
as clearing the cell and manually doing cut-paste to move up.

Sharad
 
You must log in or register to reply here.

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

Auto Fill Equations in VBA 5
Sorting question sort of 5
"Move to bottom of range" 18
MS Excel Delete row if criteria is meet 1
move data from one spreadsheet to another and repeat 1
Reduce Numbers Down To A Specific Value 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel 2013 Merge Data 2

Back
Top