Incrementing a range variable

[dannyjoer]

Hi all

I have a piece of code that runs through multiple tables (they vary in length) and replacing values. All in the same worksheet

My code looks like this:

Please Login or Register  to view this content.

I can't figure out how i get c to move to the next table and count the rows in that.
In my code c stays constant, and I need it to change and match the new row count.

Br/Danny

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[swoop99]

Can you post an example of what your worksheet with the data tables looks like?

Edit: Norie types faster...

[Olly]

Can you attach a workbook, so we can see the 'table' structure you are trying to loop through.

Edit: I'll get in the queue!

[dannyjoer]

Sure thing

If you look at the bottom of the Sample sheet, you can see that on the second table, the code doesn't change the "Plate" column all the way to the bottom.
I guess it's because the c variable doesn't update to match the correct Row count from the second table.
Any ideas?


SampleDRW050314.xlsm

Br/Danny

[Olly]

Try:

Please Login or Register  to view this content.

[dannyjoer]

That appears to be working beautifully!

Thanks a lot.

/Danny