Timeline for How to delete a column of one sheet based on value in other sheet by ignoring N/A value?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 30, 2020 at 15:09 | vote | accept | nyeas001 | ||
| Nov 19, 2020 at 14:57 | answer | added | nyeas001 | timeline score: 0 | |
| Nov 18, 2020 at 5:08 | comment | added | Rajesh Sinha |
Since in case of C2>E2(sheet1) then you are trying to delete A2:A3000 also If C3>E3(sheet1) then B2:B3000,, in that case .EntireColumn.Delete is not appropriate to work with!! Also better test cell to cell rather than with If Cells(i, "C").Value >= Cells(i, "E").Value Then !!
|
|
| Nov 17, 2020 at 21:08 | history | edited | nyeas001 | CC BY-SA 4.0 |
deleted 1 character in body
|
| Nov 12, 2020 at 20:18 | history | edited | nyeas001 | CC BY-SA 4.0 |
added 533 characters in body
|
| Nov 10, 2020 at 22:17 | review | Close votes | |||
| Nov 25, 2020 at 3:07 | |||||
| Nov 10, 2020 at 22:03 | comment | added | LPChip | Hi there, and welcome to SuperUser. We're not a "Please write me a script" kind of service. If you share your VBA code, we can look into why things aren't working the way it should or why it gives a certain error. Can you edit your post and add the VBA code? | |
| Nov 10, 2020 at 21:26 | history | asked | nyeas001 | CC BY-SA 4.0 |