array variable

I have the following vba code that runs successfully if the rows created are < 1047666. The error is thrown on the following line at the end of the script where it tries to write the output. [Sheet3!A1:B1].Resize(N).Value2 = S Any suggestion on creating multiple pages...

I am working with the following variables in a script I am writting: X: a single string variable A(1 - 18): an array that contains 18 strings I have a loop that cycles through a column of numbers (lets say column "B"), and sets X equal to B1, then B2, the B3, etc... I would like to add an...

I have an array variable that I'm looping through to calculate its values based on a row and column variable. I'm not having any issues with doing that for calculations, but one column I would like to include in the array is already in the excel spreadsheet. Could someone explain how I would...