hey everyone
i'm using a table like this one :
A B C D
1 Main | value | value | value
2 Extra | value | value | value
3 Main | value | value | value
.
.
n Extra | value | value | value
i want to delete every cell in column "D" only when cell in column "A" contains "Extra" value.
help plz
regards
Last edited by mehdoush; 02-24-2009 at 02:29 PM.
Try inserting this into a code module and running it.
Please Login or Register to view this content.
Phil
Yuck! Loops! And this one doesn't even find the end of the data or have an exit! or use defined variables ARAARARGGRGH!
How about:
HTHPlease Login or Register to view this content.
Last edited by Cheeky Charlie; 02-24-2009 at 02:02 PM.
sorry incjourn, it doesn't work on my excel workbook
ok charlie i'll try your example now!
regards!
Last edited by mehdoush; 02-24-2009 at 02:03 PM.
sorry Cheeky Charlie even this example didn't work!
more help plz
regards
it works now here's the code, i reused another code with some modif given by "incjourn":
Please Login or Register to view this content.
regards
Anyone searching and finding this thread; please don't use code like this.
Both codes work as you gave no example and barely any explanation it's not that surprising they didn't work for you.
In any case, it's spelled "thank you"
Last edited by Cheeky Charlie; 02-25-2009 at 07:35 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks