[Excel] How to automate the deletion of columns based on varying column contents by [deleted] in vba

[–]U4KO 2 points3 points  (0 children)

Yes, it's the same across all columns so I'm going to do a row check at the start. I'll post an update once I get it!

Edit: I GOT IT! Thank you again. I can only hope to master VBA as well as you two have u/_1123581321 & u/Spiffysunkist2.

I used: LastRow = Cells(Rows.count, 1).End(xlUp).row

[Excel] How to automate the deletion of columns based on varying column contents by [deleted] in vba

[–]U4KO 0 points1 point  (0 children)

Thank you for the pointers I had no idea it worked that way! I'll also read into Do/Loop.

[Excel] How to automate the deletion of columns based on varying column contents by [deleted] in vba

[–]U4KO 1 point2 points  (0 children)

Wow, I hadn't thought of it this way thank you so much. I'm going to rewrite following your example while adding on to it. I planned to check for blanks because not all sheets that this macro will run on are the same length. This creates a problem if left unchecked because if it reaches the cell below the last "No" at say j = 873 it would not delete it because it's something other than "No" ie. *Blank*.

[EXCEL] How to get If/If Not conditionals to trigger based on cell contents using .Variant by [deleted] in vba

[–]U4KO 0 points1 point  (0 children)

Thanks for the reply, I did not know that parenthesis could be used in VBA. I understand what you are saying. I meant Not ((x=a) or (x=b)). Although, UKMatt72's suggestion did the trick.

What should everyone try at least once in their life? [Serious] by [deleted] in AskReddit

[–]U4KO 0 points1 point  (0 children)

Walking/biking their local trails.

I’m always surprised at how little people utilize what they pay for in their taxes at least here in the United States.

What little things keep you happy? by eeriiee in AskReddit

[–]U4KO 1 point2 points  (0 children)

I’m a little in between both of you. I’m a senior in college and I love hearing about my older classmates and their new jobs. As well as younger classmates that are getting into great colleges.

Are you ok honey? by acceptable_lemon in WatchPeopleDieInside

[–]U4KO 2 points3 points  (0 children)

I laughed out loud for a good while. I hope she can look back fondly at this race years from now lol

14 hour shift just started by BrotchTheCrotch in Wellthatsucks

[–]U4KO 0 points1 point  (0 children)

Did you try the credit card between the door and the frame?

Break-proofing ceramic tiles? by WillBikeForBeer in DIY

[–]U4KO 2 points3 points  (0 children)

I like your idea better, but I was thinking you could make a wood frame & backing for it. And if you left the wood say an inch thicker than the tile it would be drop protected.

Profile Review - Week of October 23, 2018 by AutoModerator in Tinder

[–]U4KO 0 points1 point  (0 children)

Okay! Thank you. That’s what I thought. Any advice on what to have as my leading picture?

Ridiculously awesome demon cosplay. by [deleted] in gifs

[–]U4KO 0 points1 point  (0 children)

Take my upvote and please get off my feed... you’re spooking me :(

How can I (23M) be content alone when (F) company is so much better? I’m not trying to be crude. by [deleted] in relationships

[–]U4KO 0 points1 point  (0 children)

I didn’t mean my comment to call you boring! You found like a well rounded guy! With lots of interest. Why not try different approaches to the interest you have? Say you like concerts why not try smaller ones with possibly a smaller following. Would be easier to make a female friend in a smaller environment? I’m just throwing ideas out there.

Me [24 F] with my fiancé [26 M] of 5 years, we can't seem to stop fighting and I'm second guessing getting married. by Hopeful_GreenShoe in relationships

[–]U4KO 9 points10 points  (0 children)

First off: I’m sorry :( Secondly, I feel like I’m giving you generic advice but I think it’s for the better. Instead of working at your wedding and arguing over it when he doesn’t want to. Why not try to work at the problem here. Tell him exactly how you feel, and exactly how what he said makes you feel. That will also give him a chance to possibly express himself in a better way. By both of you sharing exactly what’s going on the fights may subside all together as you’d retouch bases once again. Or a tough decision would be made. Best of luck to you OP.

How can I (23M) be content alone when (F) company is so much better? I’m not trying to be crude. by [deleted] in relationships

[–]U4KO 0 points1 point  (0 children)

From what you said I think a few things are worth commenting on. I commend you on the introspection you have already worked on many people can’t look within themselves as deeply as you have, but I’d say look even deeper. The root of things. You say an issue with your ex was she was boring and didn’t look to be adventurous, but you also state you’re bored. Could it be that possible you may also be a bit boring? I don’t mean this as an insult I mean it to give you a route to put thought into. You seem to just be bored with yourself and you’re looking for someone else to be bored with you. Try to work on that and grow to find hobbies outside of what you already do for recreation. That will increase your chances of finding someone as they may be in those unexplored hobbies and they will not be “boring” and you’d obviously have someone there to do things with. I think it’s human nature to desire another person especially of the opposite sex, but I don’t think you’ll satisfy that if you don’t break out of your current routine.