Need to insert.

[raskinsm]

Hello,

I have a budget workbook. Within is an input sheet.

The way it works is that a date and amount is entered, then there is a category dropdown. When a category is chosen, a macro is ran based on the selection and builds another dropdown (expenses) adjacent.

Once the expense is chosen, it calculates and copies the amount entered, to a budget sheet.

This all works great.

However, what I need to do is insert a new row above this entry and it errors. I have tried a few different methods and nothing will allow me to move that entry down. I could delete it, but I'd prefer there to be a list of all entries spanning down the sheet.

Here is the code I have in the sheet (not in a module) which runs the macros based on the dropdown selections. I have included one category's expenses as well. I was wondering if my B:B and C:C targets are interfering?

Please Login or Register  to view this content.

I am hoping this is an easy beginner fix (I am not a pro by any means).

Thanks
Marc

[6StringJazzer]

insert a new row above this entry and it errors.

The code you showed does not have an insert anywhere. Please attach your Excel file, tell us the error number and error message, and indicate which line of code raises the error.

[raskinsm]

There are two things:
1. There is personal information in this sheet. Children's names etc.
2. This issue has nothing to do with existing macros, I can remove all other macros with the exception of the one on the sheet (not a module) which is pasted in the original post, right-click on Row 2, select Insert and it still will not work.

I tried to attach images but I cannot for some reason.

Let me rephrase this issue for you.

On my sheet (not in a module), I have this code:

Please Login or Register  to view this content.

All of the Case Macros are presently disabled and there is not an error.

I navigate to the sheet, I select row 2, right-click it and select Insert.

I cannot attach images because of quirky limitations, however, I describe what happens:

This error popup occurs

Microsoft Visual Basic

Run-time error '13':

Type mismatch

I click Debug

I am navigated to VBA and this line is highlighted:

Please Login or Register  to view this content.

of this line of code

Please Login or Register  to view this content.

This occurs if all my other macros are removed from the sheet.

I just want to insert a row and this (below) will not allow it.

Please Login or Register  to view this content.