Search results

I have followed the instructions found here: http://www.fmsinc.com/free/NewTips/VBA/errorhandling/linenumber.html Added line numbers manually to my code and changed my Error Handler to: Sub ErrorHandler() MsgBox "Error Line: " & Erl & vbCrLf & _ "Error " & Err.Number & ": " &...

Hi all I have an Excel VBA Macro that is called by clicking a button called Minimise. This macro reduces the row height and, hides slicers and rows that are no longer needed so I have more room on the screen. This works find in Excel 10, works in when I step through the code in Excel 13 but...

I have since solved this problem by changing my Dynamic Ranged Ranges to space and symbol delimited names (ie ValCashSales instead of ValCash for the Cash Sales Market Segment) and then added the following lines into my code to remove spaces and symbols (where required). Private Sub...

Hi fellow Chandooers I am about half way through Chandoos VBA training course but my new skills are creating demand fasting than I can learn lol! I am working on a userform with a combo box that is generated by Dynamic Named Ranges that are stored in a worksheet. When the combo box for...

I have figured out a Macro to do this that calls a Macro that filters the data fields and then inserts the field I want to use. Sub ValueAsGM() ' ' ValueAsGM Macro Application.ScreenUpdating = False Call DataFieldsClear ActiveSheet.PivotTables("SalesHistoryTable").AddDataField...

Hi, I have been playing around with the Slicer feature for Pivot Tables. It is awesome. One thing I can't figure out is how I can slice my data based on the values field. For example, I could use the slicer to select the store and have my chart return the quantity of product sold as the value...

Hi Hui Thanks for that, I will give that a try for now. There is already a limitation around number of values in each row. Ie if column A goes up to 10 and B only goes to 5 then 6,7,8,9,10 will be concatenated against blanks. Its pretty cool how you have done it, not that I really understand :)

Hi, I am new to VBA but going through the lessons now. For the moment I have a problem I cannot solve. On Sheet 1: A B 1 a 2 b 3 c 4 d 5 e I want to be able to run a macro to concatenate all values in Column A with all values in column B separated by a space. So I will get column C...

Hi All. I am Jay from Australia. Just joined Chandoo's VBA classes this week and getting stuck in. Already getting awesome results automating some of my reports at work and now developing sales applications in Excel 10. In real life I am a black belt in karate but becoming a Ninja in Excel is...

I am also interested in this functionality. I've tried to install Tabs for Excel over at http://www.extendoffice.com/product/excel-workbooks-tabs.html but once again, I have no admin rights to my machine so no luck.