I agree with Matt. The string from themoonandthelily, "right(([SearchFromEmail],[SearchFromEmail]),InStr(1,[SearchFromEmail],"@"))", causes Outlook to crash, closing it immediately when selecting an email.

Too bad, because it was a very welcome addition.

Nice Article. Get your online digital signature certificate with vakislearch. It is a simple and fast process.Digital siganture online: https://vakilsearch.com/digital-signature

Hi,

I get runtime error '424':
Object required

image attached.


Please help.

Thanks.

This macro has come in handy more times than i can count, Does anyone have a work around for these two issues? Any help is appreciated!

1. make the Macro work form a worksheet that is formatted as a table and maintain the same formatting in the new worksheets? I have been able to use this macro when the worksheet is not formatted.

2. split columns that Include blank cells from the original worksheet to the new worksheets. My original data has some empty cells, that need to remain empty, when i use this macro, the divided columns exclude the data that had an empty cell in the column that was split.

This macro has come in handy more times than i can count, Does anyone have a work around for these two issues? Any help is appreciated!

1. make the Macro work form a worksheet that is formatted as a table and maintain the same formatting in the new worksheets? I have been able to use this macro when the worksheet is not formatted.

2. split columns that Include blank cells from the original worksheet to the new worksheets. My original data has some empty cells, that need to remain empty, when i use this macro, the divided columns exclude the data that had an empty cell in the column that was split.

I tried your solution on a cell that is over 255 characters long and nothing changes. Is there a workaround for this case?

This is a really useuful resource and the code Crystal posted about automatically moving a row to another sheet based on a selection works perfectly. The problem I have is that I am moving rows from one Row (based on the selection of 'Yes' in Column O). To another sheet. But both source and destination sheets are tables. This code works bu places teh row to the next free row outside of the table not inside it? Can you help? Thx.

@crystalHi Crystal
This is the most useful info I have found on the web and this macro does what I want. But I am moving the rows from one table to another table - and with this macro the information moves ot the first free line outside of the table, not the next free line in the table? Can you help?

this code is great, but how to send the current excel sheet in the email?

Your content is very good and the posts that you share are also very good. Thank you!
https://tractorguru.com/buy-used-tractors/