Dear Sirs
I have Userform#1 (with property ShowModal=false), this form invokes Userform#2 (also with property ShowModal=false). One procedure from Userform#2 is inserting a row in a table:
sheets("data").range("top").offset(1,0).Insert shift:=xldown, copyoriging:=xlFormatFromRightOrBelow
When above line is executed, vba inserts n empty rows under just created row. Each time I do this procedure, the number of empty rows =n+1. Extremely strange behavior. WHY ? It used to be OK when I had only one Userform with property ShowModal=true. Maybe this is a culprit. But how to make it work with two Userforms being used simultaneously? Please help. Flowerski
Bookmarks