Search results for query: *

All the rows in the column

I have a column of data in Column A and I want to delete the entire row and move the rows up if the text in the cell contains a certain string. How do I get VBA to prompt me for the text and then when entered will proceed to delete the relevant rows?

Thanks for your reply and apologies for the apparant delay in responding - I have only just seen it. I tried using the code, entering the number of hours as an integer - the macro would not run with hours expressed as a decomal or in hh::mm format. The macro incurred a runtime error...

A third party application produces batches of emails for me and puts them in the Drafts folder for me to send. Thanks to the ingenuity of fellow Tek-Tips users, I have developed macros which, when I have selected one or more messages, can add specific cc/bcc addresses to them and or send them as...

The "Rip van Winkel" structure of name is not something I had considered and it does raise a very interesting quandry. That said, it does not really apply with the data set I currently generate. Right now, I would settle for everything prior to the final space to be considered as Forename(s)...

I have a column of names which sometimes contain just first and surnames, and sometimes one or more middle names, each separated by a space. I want to split this into just two columns, one containing First and Middle (if present) Names, and the other the surname. For example Jean Luc Picard ->...

I generate multiple emails from various applications, typically invoices, statements, payslips etc. It pops them into a drafts folder within Outlook365, and I have a VBA macro which sends all the drafts I have selected. However, since moving to the 365 platform, I find that many emails do not...

Is it possible to have a single button on an Excel worksheet for sorting a range alternatively by two different columns, say Reference and Name? Ideally, I would like the button to read "Sort by Reference", then when clicked, a macro would sort the data by reference number, and then change the...

Is it possible to have a an Outlook VBA macro which will export the header information from emails the user has selected? Any code / advice would be much appreciated. Thanks