Buttons not always moving deleting rows. Odd behavior

F

Frank

Here is a problem I can’t seem to resolve.

I have an execution button on a sheet (sheet01) to clear my workbook.

On sheet03, I have rows to be deleted. On one row, there are “up-down”
sort buttons which needs to move up.

Here is the code

Sub button_delete_all()
If Range("pv_copy1").Offset(1, 0) <> "" Then
Range("reporting1").EntireRow.Delete
If Range("pv_copy2").Offset(1, 0) <> "" Then
Range("reporting2").EntireRow.Delete
End Sub

Pretty straight forward, right?

When I open my workbook and directly run the macro, the “up-down” sort
buttons on sheet03 do not move with the deleted rows. But (here is the
kicker), if I select sheet03 and go back to run the macro, the “up-
down” sort buttons move as expected.

I am puzzled and wanted to run it by experts (I am not a programmer by
trade).

I’ve uploaded my test spreadsheet at http://home.comcast.net/~gegene/test..xlsm

I am using Excel 2010 and Windows 7.
 
F

Frank

Hi Don:

That's not it either.

Here is what I found out:

It will work if you add the following:

Application.ScreenUpdating = True
Sheet03.Select
Sheet01.Select

But if you change to ScreenUpdating = False, it does not work.

I don't understand why sheet03 needs to be physically selected (and
shown as such) for these rows to properly delete.
 
D

Don Guillett

Hi Don:

That's not it either.

Here is what I found out:

It will work if you add the following:

Application.ScreenUpdating = True
Sheet03.Select
Sheet01.Select

But if you change to ScreenUpdating = False, it does not work.

I don't understand why sheet03 needs to be physically selected (and
shown as such) for these rows to properly delete.

I repeat. You don't have a named range you are using...
 
F

Frank

Hi Don:

Thanks for the reply.

The named range was there but it was hidden.

I've uploaded the spreadsheet with unhidden named ranges.

Of course, the names disappear after the macro goes through.

But essentially the problem remains: Sheet03 must be "physically"
selected otherwise the "sort button" won't move with the deleted rows.

It's just bizarre.

Regards.
 

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

Top