Array VBA Redim help.

So I have this VBA code heavily modified from a source. Although the code looks complicated, I have this problem that I think could be solved in a simple manner (for experienced guys, at least :\ )

Please Login or Register  to view this content.

I needed it such that when I change the value of "nobs", it would give me the exact amount of 'observations' I need regardless of how many data points I use for VLE_FIT. Basically this means I am going to use the 'function method' in gathering the data points from the sheet, then resizing the array formed by the data points.

Sadly, I always end up with an error. I don't know why does it keep on creating errors, I already made sure that the iterations for the array generation would end at 'nobs'. Basically this means on the "Const nobs As Integer = 201", when I change 201 to 25, it would only need the first 25 data points and would discard the rest. Care to look at this, anyone? I'd appreciate any form of help. Thanks!

CROSS-POST LINK: http://www.mrexcel.com/forum/excel-q...edim-help.html

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

==========
Crosspost located here: http://www.mrexcel.com/forum/excel-q...edim-help.html

Okay, will do. I wasn't familiar with such a rule, sorry. I just really needed help.

Edited the main post.

If an array variable is initially declared with explicit indices, it cannot be redeemed.

Please Login or Register  to view this content.

if you anticipate redeeming an array, initially declare it without any indices.

Please Login or Register  to view this content.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets

I made the following changes which should get you closer:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The program isn't iterating anymore. I'll figure out what happened.

EDIT: It doesn't work. :\ the new array continually lists the parameters regardless of the value of nobs. This is so hard and is impossible to solve I guess (