Deleting range given location of pressed form control

TrackerHelp.png

Hey folks,

So I'm trying to delete the form below the "Remove" button and the button itself, and then take the data below and move it up to fill the gap (the random numbers are just to test the xlUp piece). Here's what I have so far:

Please Login or Register  to view this content.

Basically my idea with the third line of code is that it starts from the location of the button pressed, and then names a range with the dimensions I want to delete.

Anybody able to see what I'm doing wrong?

Bump, no response.

I attached a photo of my worksheet as a visual aid - let me know if it's not viewable.


will post workbook with redacted personal info if somebody wants to see the workbook.

Hi AaronChurchill

This is always a good idea...

will post workbook with redacted personal info if somebody wants to see the workbook.

Include any Code you're currently using whether it works or not. Also, please include an "After" Worksheet that displays your desired output.