Looping through cells

[FancyCorndog]

Hi,

I'm trying to loop through a specified number of cells (defined by width and height), but I'm running into problems here. It keeps stalling on me, and then gets upset about:

Please Login or Register  to view this content.

It's giving me an "Application defined or object defined error"


Can anyone tell me where I'm going wrong with my code:

Please Login or Register  to view this content.

[dominicb]

Good evening FancyCorndog

In your code you need to refrain from using as variables any words that could be construed as standard VBA instructions (in this case "Min" and "Max").
Change them in your Dim statement, and everywhere else they are mentioned and try again.

HTH

DominicB

[FancyCorndog]

Good evening FancyCorndog

In your code you need to refrain from using as variables any words that could be construed as standard VBA instructions (in this case "Min" and "Max").
Change them in your Dim statement, and everywhere else they are mentioned and try again.

HTH

DominicB

Thanks for your help!

I changed min and max to minVal and maxVal, but I'm getting the same error.

Please Login or Register  to view this content.

[dominicb]

Hi FancyCorndog

Can you upload a workbook of what you have so far?

DominicB

[FancyCorndog]

It's too big to upload on the site but here it is from Google Docs:

https://docs.google.com/open?id=0B7K...0paUS1wdHJySGs


edit: It's supposed to run from the "Raw Data" sheet.

[FancyCorndog]

The problem was that I forgot to reset width on each row.