Autofill columns and rows simultaneously

I'm wondering if there is a way to autofill colums and rows simultaneously.

Right Now I have a formula in B3. I want to autofill it over to AD and down to row 40. The following code works:

Please Login or Register  to view this content.

but if i change y to:

Please Login or Register  to view this content.

the autofill doesnt work. is there a way to do this?

Thanks,
Joe

sorry, forgot to mention.... the formula in B3 is an arrayformula and needs to stay that way. your code works with a regular formula tho. any ideas on how to do it with an arrayformula?