Questions tagged [rowdeleting]
91 questions
0
votes
2 answers
How To Delete Every Row In A Table While Protecting First Row?
The following code should delete every row but the first. However, it deletes every second row.
Dim index As Long
For index = 2 To ActiveDocument.Tables(1).Rows.Count
ActiveDocument.Tables(1).Rows(index).Delete
Exit For
Next
Mohamad Bachrouche
- 131
- 10
0
votes
2 answers
Deleting Rows On A Set Date/Time Criteria in Excel
Hey I've been trying to find a way to delete the rows I need via formula without having to do change to much before it works.
When I download CSV, it stores time/date like…
1sbro
- 1
0
votes
1 answer
JTable problem - deleting a filtered table
I am doing a project in Java and use a jTable with a column with Buttons to delete the row. This work well. After that i added a textfield to filter the tablet and work too. The problema was when i try to use the 2 things. I search for a row and…
Luis Cruz
- 1
- 1
0
votes
1 answer
VBA How to Delete Table Rows
I have a table which can vary in range (rows only) depending on the numbers of inputs (rows).
I've written a code to transfer the data from the table to my data base. That's working fine.
But, at the end of this script, I'd like to delete the table…
Greg
- 19
- 6
0
votes
2 answers
Trying to delete rows with NAs, so that I can do chi-square analysis
R community.
I am trying to delete the rows TEMPORARILY that have NA, so that I may conduct a chi-square analysis on my data. Otherwise, there would be a column titled "unknown" when I choose two variable to make a data table, and that would…
Brian
- 31
- 3
0
votes
1 answer
Deleting empty rows within a table
I am new to Google Apps Script script writing and trying to self teach by starting off making a generic table. So far I have:
made a header;
changed the background;
changed the font;
added data validation;
added thick outside borders as well as…
Shea Murphy
- 5
- 3
0
votes
2 answers
How Can You Delete All the Rows In a Range?
I'm new to vba, and I've written the code below but can't figure out why it's not working.
Sub DataValidationDeleteWrongOrigin()
'
'Description: Goes through and deletes rows that are called out on the delete entry column.
'
'Dimension…
sa.key
- 3
- 3
0
votes
4 answers
Deleting a row not working in UITableViewController
I have a dictionary that I have made called places and I made each cell in the tableViewController show each parts of the dictionary. I know the function to delete the rows in the controller, but when I run the app and do the action of deleting…
Ishaan Sathaye
- 23
- 7
0
votes
1 answer
How to delete the rows in a dataframe with zero values in R
I want to delete the rows that are having values which are all zeros.
This is how my data set looks like:
ChildBks YouthBks CookBks DoItYBks RefBks ArtBks
1 0 1 0 0 0
0 0 0 0 0 0
…
user11139847
0
votes
2 answers
Deleting records that are over 4 years old from today's date on MySQL
I want to delete records from my table when an end-date column is over 3 years expired past the current date
See below for what i have already tried
DELETE FROM membership
WHERE (SELECT EXTRACT (YEAR FROM end_date)) <
(SELECT EXTRACT (YEAR FROM…
Gary Mannion
- 29
- 7
0
votes
2 answers
Having an issue deleting rows from server
So in short i am having issues getting my code to remove rows from my database table "tblsurvey" when i run the code there is no errors displaying and it appears to execute the statement correctly however when checking the table i find the row has…
Sam Austin
- 11
- 2
0
votes
0 answers
What is the meaning of assigning to an empty matrix in Scilab?
In one of my programs, I wanted to delete a row of a matrix. I found this video tutorial online. It says that to delete, for example, the first row, write
A(1,:)=[]
However I don't understand what this exactly means. The LHS is simply the first row…
hello_world
- 29
- 10
0
votes
0 answers
Deleting Vector Elements in Python without deformation
Im learning Python for a CS class and we just started using numpy and scipy for more mathematic functions. One of the exercises was to delete every second element from a vector of size 100, which in itself was not a big problem.
import numpy as np
v…
LucaW
- 79
- 1
- 6
0
votes
1 answer
Gridview remove items
I have I gridview in which the data source is a List. When I try to remove an item from the gridview in my buttonRemove_Click() function another function which handles the RowDeleting event is invoked where I remove the item from the List as…
Tux
- 77
- 1
- 2
- 10
0
votes
1 answer
type mismatch error: Excel VBA, loop column A for value, delete current row and rows beneath it until next value
I am having an issue with EXCEL. I am trying to loop through some data in Column A to match those values against a list on another sheet. If the names appear on sheet 2 it should select that row and delete it as well as delete all rows that follow…
Checht
- 45
- 10