Keep Row Height of Deleted Row that Shifted

[guitarsweety]

I'm using the macro below to delete a row, which works but is there a way to keep the row heights for the row that is shifting up?

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.

[guitarsweety]

I just tried it but it didn't work

[guitarsweety]

I've attached the workbook if that would helpTN Test SBA.xlsm

[guitarsweety]

I know there's someone out there that can help !

[shg]

You're not helping yourself much here.

Where's the button that invokes the code? What happens when you step though it?

[guitarsweety]

Its the Delete Record button on frmEntry

[guitarsweety]

Ok, so I got something that partially works, but it's pulling down the data in the last column to the rowNow

Please Login or Register  to view this content.

[guitarsweety]

I removed the line below and got it working properly

Please Login or Register  to view this content.

[guitarsweety]

So my project is complete with many many headaches and a lot of help from the forum. I've learned a very valuable lesson in all of this... Refrain from merged cells... It really does create havoc.