charlottedv
New Member
- Joined
- May 14, 2024
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi!
I'm trying to add a blanc row everytime there's a change in data in one of my columns.
I've read already some other threads with similar questions like: Thread 1 and Thread 2 but none of the codes mentioned here seem to work for me.
I get the error: "types do not match". Could it have to do with the fact that my office language is set in Dutch? (belgian user here
)
In this image you can see the basic set up of my data sheet.
I would need a blanc row everytime the column "Variantcode" changes.
Any solution or help to automate this proces is welcome, VBA or basic excel actions.
I'm trying to add a blanc row everytime there's a change in data in one of my columns.
I've read already some other threads with similar questions like: Thread 1 and Thread 2 but none of the codes mentioned here seem to work for me.
I get the error: "types do not match". Could it have to do with the fact that my office language is set in Dutch? (belgian user here

In this image you can see the basic set up of my data sheet.
I would need a blanc row everytime the column "Variantcode" changes.
Any solution or help to automate this proces is welcome, VBA or basic excel actions.