@Alansidman: It gives the same method range global failed.
@Norie:
LastRow = 533 when I highlight LastRow after I run the above code. That is the correct #.
LastRow remains equal to 533 when I highlight LastRow in the line
Could it have something to do with a limitation in VBA (kinda like the 22 or so if statement limit)? I wonder if its just a coincidence that it starts at AA (i.e. two letters)? I got part of the formula to work by using
But I cant figure out how to autofill down this (I tried using both Range and Cells. It only works if I use the # 533 not my variable)
Bookmarks