Forum Discussion
Auto populating the date when a value is changed
Hoping someone can help. I have a excel sheet where column x has a drop down option of listing "Open" or "Closed." Whenever a new row is added, I need to mark it as open but eventually once the proje...
Yes, that's it exactly!!! If I have a table and I add more than 25 rows, will it still work? Thanks so much!
Set rngBereich = Range("W2:W25")
It works depending on the range in the VBA code. The example works for rows 2 to 25. But you can easily change the range to e.g. "W2:W200" and it works for rows 2 to 200.