Hello Excellers and welcome to another #MacroMonday #Excel blog post in my 2020 Excel and macro series. Today let's look at removing your Personal Macro Workbook from Excel. This workbook will be named personal.xlsb in Excel versions >2007 and if you have a version of Excel prior to 2007 then the workbook will be called personal.xls. If you don't need or use the workbook then you can just delete it. There are a few steps to it so just follow along. Here are some other blog posts you may … [Read more...]
Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know that you can change the case of text using the Excel PROPER function. What the heck does that mean?. Well, say you have text like this. I lOVE eXcel. If you apply the PROPER formula to this cell, Excel will happily convert your text string to 'I Love Excel'. This is converted to the correct case for … [Read more...]
Macro Mondays – Using An Input Box To Determine Which Excel Rows To Delete.
Hello, Excellers and welcome back. It is time for another installment in my #MacroMonday #Excel blog posts in my Excel 2o20 series. This macro, using an input box, really is a time saver and once used, it is never tucked far away from me in my Excel and Macro toolbox. I am going to show you how to delete rows in your Excel worksheet. However, instead of having the parameters that determine which rows to delete 'hard-coded' into your Macro, I will be using an input box that allows the user to … [Read more...]
How To Delete Cell Content In Excel With Simple VBA
Hello, Excellers welcome back to another #MacroMonday #Excel blog post in my 2020 Excel and VBA series. Do you do the same thing over and over again in Excel?. DO you want to get automating with some simple macros and VBA?. Well, here is a great simple macro to get started on that journey. Today I will show you how to delete cell content with a simple Excel VBA macro. If you repeat the same actions over and over again on a regular basis then creating some simple code to reuse will save a … [Read more...]
Concatenate A Range Of Cells With VBA
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 Excel and Macro series. The macro I am going to show you today is one I use on a regular basis. It will concatenate a range of cells (account references) and builds a large one-line row string. Each of the account references is separated by a comma. I use this to query a database with a bunch of customer references as a single strong, at once instead of one by one. Time and sanity saver right there!. You … [Read more...]
- 1
- 2
- 3
- …
- 33
- Next Page »
Recommended Excel Resources
