If the data in Column J is 1 then I need to copy that row and insert. Click Here Before Posting Data or VBA Code - How To Post Data. Vba Code: Delete Entire Row Based On Condition - Excel. Typically I would just filter on that value and delete the rows, but I am not sure if that is a possibility in VBA code. Can you provide the code if not too complex. Select Cell A1 if value is 100 delete entire row, else skip to next row. Then loop through each row in the spreadsheet till all rows with selected cell equal to 100 are deleted.
Active2 years, 5 months ago
Heres my code, but its not really doing anything, I dont see anything wrong with it:
My intention is that when that specific cell in the previous row is set to 'Passed' from the dropdown, then the below row would appear, if its a 'Failed' then it'll be hidden instead.
nixda22k1111 gold badges8282 silver badges140140 bronze badges
I AM LI AM L
3 Answers
It looks like your code has some typos in it. You want something that is like this:
To have the row hide/unhide update as you change the sheet, put it in a
jonscajonscaWorksheet_Change
event:3,7341414 gold badges3030 silver badges4545 bronze badges
there was no typo. 'rows(51)' is valid. but you don't need the 'entirerow' modifier
to hide multiple rows
suspectus3,87666 gold badges2121 silver badges3131 bronze badges
MudcatMudcat
Excellll11.4k77 gold badges4242 silver badges6464 bronze badges
Raul GonzalezRaul Gonzalez
protected by Community♦Apr 3 '17 at 13:38
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?