Method 'range' of object '_global' failed.

**johnmerlino** · 02-25-2011, 02:08 PM

Hey all,

I have cells in column A like this:

John, Merlino
UNKNOWN SPOUSE OF John Merlino

I have this macro:

Please Login or Register  to view this content.

I have this macro because there could be other things I want to clean out of cell in future so i can easily just add it to this list.

Problem is when I run this macro, I get this error:

Method 'range' of object '_global' failed.

**brokenbiscuits** · 02-25-2011, 02:30 PM

Try 'cells' instead of 'range':

Please Login or Register  to view this content.

Does that work?

**johnmerlino** · 02-25-2011, 03:05 PM

Thanks for reply, but your solution doesn't go through the length of column a. for example, if there's two cells in column a, it will only modify the last cell into column b.