Hello,
I have been quite unsuccessful in finding information towards solving this problem. In fact, I haven't had much luck at all in the problem of selecting columns. What I am trying to do is if a cell in row 3 equals value "delete", then delete the entire column, and continue through that row until last column. Any help towards solving this would be greatly appreciated.
Last edited by henboffman; 01-06-2011 at 07:52 AM.
This macro should do it:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JBeaucaire,
Thank you, worked like a charm!
Ben
Originally Posted by JBeaucaire
This macro should do it:
Please Login or Register to view this content.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks