Formula: Button that Clears a specific table array of information

[ccwbass]

Need a formula to create a button that will erase a specified table array of data.

So customers would be able to PASTE a received order within a specified table, and when they are finished they can click a button that says CLEAR or ERASE, and it removes that data pasted.

THANKS CREW!

[dflak]

I assume we are talking about an Excel Table. Call this subroutine from another subroutine with the following syntax: ClearTable SheetName, TableName.

It resets filters so there are no hidden rows in the table that won't get cleared and removes the data.

Please Login or Register  to view this content.