How to insert more conditions in if-statement

Hi guys

I am working on a search and replace macro. It's purpose is that within a region that varies only in row size, it's suppose to compare two
values, A and B. A is only placed in one cell in the region, while B is a one column range in the region.

If A <> B, A should replace all B's in the region.

These regions are placed on top of each other in a long table. Please see the sample workbook, SampleDRW.xlsm

The code I am using is this:

Please Login or Register  to view this content.

The problem is if the B value in the next region is the same as the one before but the A value change, my code don't pick up on it, because it only looks for changing B!
How can I expand the code to also pick up on this problem?

Any help is very appreciated.

Br. and happy friday!

Danny

Hi Danny,
try it

Please Login or Register  to view this content.

Thanks a whole bunch nilem. A small little detail, and forgive my ignorance; the individual boxes vary in length,
but it appears that with the CurrentRegion command, the code makes all boxes equal in length. This means that it
inserts a lot of redundant values after the individual tables end.

Should I change parameters in the .resize command to adapt to each individual box?

Br/Danny

Hi Danny,
try it

Please Login or Register  to view this content.

Thanks nilem

The code gives me an 'subscript out of range' run-time error.
But it looks exactly like the old one.

Could you show an example of the file where the error occurs

Sure thing, the error occurs in this Sample workbook..

SampleDRW060314.xlsm

I can't figure out the error..

Br/Danny

Sub ertert()

Please Login or Register  to view this content.