1. I

    How to edit this VBA line to an array for better optimization?

    This full code pulls data from a work website into Excel. Can be up to 55000 rows. Currently on Excel 2019 it takes forever to run. Also uses between 33%-50% of cpu. On 2016 it worked fine. I use a code already that turns off all things like calculations, events, etc. I am thinking an array...
  2. S

    How to get Multiple items and sum up the same using GetPivotData?

    Sub Reconcile() Dim InputworkBook As Workbook Dim ReportsToReconcile As Variant ReportsToReconcile = Array("Report1", "Report2") Dim ReconcilingReport As Variant Dim ReportIndex As Integer ReportIndex = 0 Set InputworkBook = Application.Workbooks.Open(Application.GetOpenFilename, ReadOnly:=True)...
  3. S

    How to GetPivotData passively?

    This works... .GetPivotData(PivotEntity) But Not this... Evaluate(".GetPivotData(" & PivotEntity & ")") How to make this work? If not... Is there any other alternative command available. Please Help. Thank You
  4. L

    Strong typing TempVars

    Hello. When developing, I have found it convenient to use TempVars because they maintain state even when my VBA project does not. In addition, I don't have to run a load procedure every time I restart my code. To provide a bit of validation and intellisense, I wrap them in properties in a...
  5. S

    How to call a button click from another Macro?

    Hello, There is a button click private sub on another sheet, I just want to invoke it from a macro. The below doesn't work: CallByName Sheet30, CommandButton10_Click, VbMethod Is there a better approach?
  6. P

    Mimick a first click of a created on demand object

    I have a userform that during run time creates 256 individual labels (they represent 5 charts with 53 weeks of data). This works great, I move the axis and scale as needed, I color code them based upon data in the spreadsheets, they have control tips to show their full value.s I also have...
  7. C

    Too tricky?

    Hello, I'm struggling for a while with a generic mechanism to assign some short-cuts to methods that are implemented in classes. This is what I have so far: In a class module ("test2"): Private Sub Class_Initialize() Dim var(0 To 1) As Variant var(0) = 5 var(1) = "ThisIsAstring"...
  8. craig.penny

    Naming Variables With Other Variables?

    This might be a ridiculous want but I'll ask anyway. I'd like to be able to create a number of variables based on user input. Something like this: '------------------------- Dim Counter as long Dim X as long X = inputbox(prompt:="Enter Number of Blah Blah") For Counter = 1 to X Dim...
  9. E

    Calling Procedures in Another Workbook and Passing Variables

    Hello- I have a VBA Routine where I open workbook and run some code in the newly opened workbook that requires two input parameters...I've been trying to pass them ByVal however the debugger now does not recognize the Call to the procedure if I include the variables...anybody have any ideas on...
  10. craig.penny

    using string to call a userform

    Hi all, I have a string variable which I have succesfully passed to a sub in a userform. The variable is used to call a second userform from the one it was passed into. My problem is that I have no idea how to execute the %^&$ thing. Suppose I have a variable MyVar = "MyName" which...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back