Macro autofill stops working at Column AA? (method global failed)

Try this instead of your three lines of code.

Please Login or Register  to view this content.

What does "This doesn't work" mean. Did it error out in the VBA. If so, what was the message. Was the line in question highlighted or another line? Did it return unexpected results. Need more information to help resolve. When I run it, it returns the formula in each cell in column AA to the last row indicated so I don't know what your issue is. Perhaps you should upload your worksheet for further analysis as we are only seeing a very small piece of the puzzle.

What's the value of LastRow when the code errs?

@Alansidman: It gives the same method range global failed.
@Norie:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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)

Can you upload an example workbook?

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

I don't want to upload any files for security reasons but I will put the full code below:

It doesn't matter if you press Yes or No for the msgbox part but I always press yes. The error comes in another part of the code.

Please Login or Register  to view this content.

The code causing an error is:

Please Login or Register  to view this content.