dimensions

I start with a 1D array, e.g., Array1(1 to 24), and would like to add a dimension and convert this to a 2D array, e.g., Array1(1 to 24, 1 to 36), while retaining the original values from the 1D array. I tried the following, but the VBA routine exits with an error: ReDim Preserve Array1(1 to...

Hello, We are working on a warehouse layout, which has huge floorspace, using excel spreadsheet. the layout scale is good enough to represent each square cell as One Square foot. We're trying to measure certain areas by highlighting group of cells, no matter if they contain values or blank...

I'm making a program that will rearrange scatter plot labels so they don't overlap. It's almost finished, but there are a few more kinks I need to iron out. 1. For some reason ActiveSheet.ChartObjects(1)'s dimensions are not right (I have only one chart on the sheet). From what I saw the height...

Hello – Our team has been using an xls Marco to retrieve the files in a specific path provided by the user. There is a button on the sheet that runs the below Marco. This has been working perfectly for years however the new ask is for the Marco to return the image dimensions (as in 2189 x...

Hello, I have a N-dimensional array called "Data", where the number of dimensions N is variable... How can I extract a 1-dimensional array from this, comprising all elements along the Xth dimension, which are the first element along all the other dimensions? For example, this would be...

I am working with dynamic arrays that may be assigned from a variety of sources (variable ranges, data strings, or other arrays) and need a simple way/function to count how many dimensions an array has at any moment, so that I can use other functions to manipulate the array in the correct...

Hi All Members this is my table, [200 countries in columns and more than one million codes in rows] <table style="border-collapse: collapse; width: 227pt;" border="0" cellpadding="0" cellspacing="0" width="302"><col style="width: 41pt;" width="55"> <col style="width: 62pt;" width="83"> <col...