Autofill and function not working Need HELP!

I have the following function code

Please Login or Register  to view this content.

listed in cell V2 on sheet 1. After that is placed i then run the following macro for an autofill.

Please Login or Register  to view this content.

The problem I'm running into is that the pasting of the function and the autofill are not working correctly and I do not know why. The corresponding cells that are suppose to increase with the autofill are not increasing. It should be A2 for row 2 and A3 for row 3 and so on. Any suggestions are greatly appreciated.

Maybe:

Please Login or Register  to view this content.

Originally Posted by HaHoBe

Hi, trevor2524,

just combine the codes instead of writing the formula first and then using Autofill:

Please Login or Register  to view this content.

Ciao,
Holger

Thanks that one works the only thing it is needing now is how do i add the crtl+shift+enter to that macro so that each cell after the function it does that.

I think i see what your saying. Ok i'll try and figure out another way to go about the whole process and see if there is someway I can manipulate it. I'll post if I have any more questions. Thanks again for your help. It helped out alot.