join cells in excel

How to Join Cells In Excel with a Comma (or other delimiter)

There are times where I need to join cells in Excel and separate them with a comma or some other text. I usually need this to make a SQL query or something like this. Whatever the case may be, Excel doesn't seem to have an easy way to join multiple cells with a delimiter like a comma. So I've created a ...
application.screenupdating

Application.ScreenUpdating can dramatically speed up your code

Whenever you have a task to automate, you can usually go down the VBA route. And usually when you write your code, you're just trying to get things to work. You know how it goes. Write some code, test, then fix the bugs. Maybe later you add some features here-and-there, making your VBA code more powerful. But after a while ...

Excel VBA for Beginners

If you’ve done a lot of work in Excel, you’ve probably heard about Macros or VBA. Excel VBA can help you do your work much, much faster. It can also help you expand the true power of Excel in ways you never thought possible. Ranging from processing data in a worksheet all the way to scraping web pages, VBA is …

Using Enum to Keep Track of Worksheet Columns

If you code much in VBA, you have probably had to manipulate worksheets at some point. There are some common ways to work with worksheets through VBA. You have the Range object, where you can write in a string of the address you need to access. And you have the Cells object, where you use the [Row,Column] notation to access …

Hyperlinks are lost after sorting – VBA fix

After I wrote my post about creating hyperlinks with external data, a subscriber told me about a problem they were having and was wondering if I could help.  The issue was that when they sorted hyperlinks after they were recently copied from one range to another, some hyperlinks would be removed from the range while others remained intact.  I hadn’t …