hello excelers,
Is it possible to make it work if the active cells inside any table and not just specific one ? and that the code will know which entire rows included in the active cells ?
it seems like a tough one
hope for a miracle on this one,
thank for any help at all,
best regards,
netanel
Last edited by netanel99; 07-02-2017 at 10:51 AM.
Please clarify
Please clarify exactly what you are trying to do. Upload a workbook with a before and after situation so that we can understand the end goal.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You cannot have active cells. You can select a range of cells, but only one cell is Active.
Perhaps this thread will help.
VBA delete table row based on selection
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I'm sorry, I'll clarify more,
my end goal is a button that checks if the selected cells (thanks AF) are inside of a table (all of the selected cells) , and if the selected cells are all inside a table it will delete the entire rows of the selection, and if the selected cells are not all inside one table then it won't do nothing
really hope for something that will work on every table, and could either delete few rows If there was multiple selected cells, or one entire row if the selected cell/s are in one row, in every other situation nothing will be done by the macro.
is it possible to have this work ? I've seen a code that works but it takes 4 min for me to use that code to delete 70 rows all in once.
thanks for your willingness to help and your knowledge ! really.
I've found this place , it does everything perfectly , My one and only problem with that is that it deletes the table's row and not the entire rows , is it possible you could modify it just so it'll delete the entire rows because it seems that the guy who done this made very prolong and hard work on it and very proud of his creation, and it's works great. he put a function that must be added also in order for the main "sub" to work.
https://www.thespreadsheetguru.com/t...eet-protection
thank u so much again!
As said, please upload YOUR workbook.
We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.
Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
Would you also change your location to something meaningful. It often helps when we have to consider regional settings or date formats and other stuff.
You are absolutely right, thanks for the patience and continuation .
This example includes a Working code -which is great,
the only problem it deletes the row inside the table - I really hope it will delete the entire rows - because then all my pictures and shapes bellow won't be messed up.
I'm really hoping there is an easy adjustment on this one.
thanks again and again.
ahh... unbelievable I think I made it by a chance .
I just changed
to this one
Please Login or Register to view this content.
and apparently, everything works perfectly, Doubled checked I think it's ok, This guy's nick: thespreadsheetguru he's got a site , seems like he just invested hours on this, 360 degree works.Please Login or Register to view this content.
Last edited by netanel99; 07-02-2017 at 01:50 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks