Impossible?

[raskinsm]

Hello,

I have posted this on 3 other forums and no one has responded. It seems like a doable request. Maybe a not-so-advanced user has an advanced scenario? It doesn't seem outlandish to insert a row once data is input.


I have a macro written on a specific sheet (not a module). What it does is when a selection is made in the dropdown in C2, it populates, in the adjacent cell, D2, another dropdown depending on the selection in C2.



This works perfectly.



However, this configuration will not allow me to insert a row, which pushes the data in Row 2 to Row 3.



Here is the code on the sheet.

Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C:C")) Is Nothing Then
Select Case Target
Case "Home Expenses": CAT_HM
Case "Daily Living": CAT_DLE
Case "Children": CAT_CHLD
Case "Savings": CAT_SAV
Case "Obligations": CAT_OBLIG
Case "Entertainment": CAT_ENT
End Select
End If
End Sub

When I insert a row, I get MSVB error: Run-Time error '13': Type Mismatch





When I click Debug, it sends me here:











Any help would be epic, I have been struggling with this. I have also tried copying and pasting, cutting, deleting and pasting. Come on, do me a solid on this Friday.



Thanks

Marc

 

[raskinsm]

I don't remember and I am not searching my history, I have too much going on. I will delete the post and never ever ever say that again.

Would you delete that post please.

 

[raskinsm]

I don't remember and I am not searching my history, I have too much going on. I will delete the post and never ever ever say that again.

What a pain in the as# - Delete my entire account. How stupid.

 

[Michael M]

If you continue to use a Worksheet_Change event, I'd suggest you need to turn off events first.

Application.EnableEvents = False

and then turn back on at the end of the code.
Otherwise you will get caught in an infinite loop.


Also, the problem with cross posting without the links to the other sites, is that if someone else is working on the issue at another site, they, or us, may be wasting their time because it may already have been solved. Keep in mind we are all unpaid volunteers.

 

[raskinsm]

If you continue to use a Worksheet_Change event, I'd suggest you need to turn off events first.

Application.EnableEvents = False

and then turn back on at the end of the code.
Otherwise you will get caught in an infinite loop.


Also, the problem with cross posting without the links to the other sites, is that if someone else is working on the issue at another site, they, or us, may be wasting their time because it may already have been solved. Keep in mind we are all unpaid volunteers.

Thanks for the info and the recommendation. Initially, I googled one site and asked the question as a guest. Another I put in a request to cancel my account because their forum platform was very bad. I decided to use and stay with this one because there was responsiveness and the platform is quality. Now I know. I would have to comb through my history and or inbox and I just do not have the time. I will never go to or post to, those forums again.

 

[Michael M]

The best thing I can suggest then, is if you get a response back from either of those sites, you post the response back here so it can be noted in this thread, so others can refer to that site.