I am having many kinds of names in my excel sheet. Now i need only one particular name. So i am filterting that name, now the excel will display only the rows where the selected name is present(say its 10th and 13th row.) Now when i right click and give delete rows, excel crashes.
As per my initial analyses i found out that the data area given by excel is giving wrongly. When i press control and choose the 10th and 13th row, it got deleted. I debug and try to see the difference between both. When i press control and delete, in the range i got area to be deleted as " range = area #1 = [PSet_Signal_Editor.xls]Signals!$13:$13; area #2 = [PSet_Signal_Editor.xls]Signals!$10:$10; "( the area of 10th and 13th row) but when i filter and delete the rows i got the target range as " range = area #1 = [PSet_Signal_Editor.xls]Signals!$A$13:$F$13; area #2 = [PSet_Signal_Editor.xls]Signals!$H$13:$IV$13; area #3 = [PSet_Signal_Editor.xls]Signals!$A$10:$F$10; area #4 = [PSet_Signal_Editor.xls]Signals!$H$10:$IV$10;"
I got 4 areas like from A to F; H to IV, I dont kw why the area is spliting like this. So when I try to get the count of the data area its giving the wrong count and excel crashes. As the data area is getting from excel, in my project i cant do anything. So is there any work around to do im my project, so that i can get the area correcly using that getcount() method. In my getcount() method, i shud get the same value as pressing control and when filtering.
Please give your valuable suggestions
As per my initial analyses i found out that the data area given by excel is giving wrongly. When i press control and choose the 10th and 13th row, it got deleted. I debug and try to see the difference between both. When i press control and delete, in the range i got area to be deleted as " range = area #1 = [PSet_Signal_Editor.xls]Signals!$13:$13; area #2 = [PSet_Signal_Editor.xls]Signals!$10:$10; "( the area of 10th and 13th row) but when i filter and delete the rows i got the target range as " range = area #1 = [PSet_Signal_Editor.xls]Signals!$A$13:$F$13; area #2 = [PSet_Signal_Editor.xls]Signals!$H$13:$IV$13; area #3 = [PSet_Signal_Editor.xls]Signals!$A$10:$F$10; area #4 = [PSet_Signal_Editor.xls]Signals!$H$10:$IV$10;"
I got 4 areas like from A to F; H to IV, I dont kw why the area is spliting like this. So when I try to get the count of the data area its giving the wrong count and excel crashes. As the data area is getting from excel, in my project i cant do anything. So is there any work around to do im my project, so that i can get the area correcly using that getcount() method. In my getcount() method, i shud get the same value as pressing control and when filtering.
Please give your valuable suggestions
