dyanmic array

  1. P

    Dynamic Arrays in VBA With If Statements and For Loops

    Hi guys, Happy Monday. I am trying to make a dynamic array that gets its values from a range in a worksheet. I am not too familiar with arrays in vba and I am having some trouble. From what I can have seen with some perusing, I assume I might need to use the redim function, but I am not...
  2. S

    Dynamic Charts

    Hi Guys, Is there a way that I can automatically update my charts without putting the information in manually. I want to preferably do this without name tags Thanks Steph
  3. L

    Compile Error: Constant Expression Required

    I am receiving an error message "Constant Expression Required" from the following code: num_xmitters = ThisWorkbook.Worksheets("Instr List").UsedRange.Rows.Count Dim TransmitterArray(1 To 4, 1 To num_xmitters) As Range I do not feel that this range is varying since the used range on...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top