Deleting Last Record in Spreadsheet Causing error

[gunsmith01]

In deleting the last record in a spreadsheet, it is causing the following error: "Run Tie Error - Cold not set the value property - Type mismatch

The following code using to delete

 

[hiker95]

gunsmith01,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


In order to assist you it would help us if you posted your macro code using code tags.

When posting VBA code, please use Code Tags - like this:

[code=rich]

'Paste your code here.

[/code]