Selection.AutoFill ISSUES

[batchy]

Hi All,

I would like to Copy the formulas in the range A2:AR to the bottom of my data in Column A and then auto fill vs column AS:

This is the formula which I currently use is:

Please Login or Register  to view this content.

Instead of using the above i want the formula to use the selected cells and copy down vs column "AS"

Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[batchy]

Hi John,

I'll try and explain a little better:

Within A2:AR2 I have a group of formulas which populate my calculations.

Rows 3:28 were previously populated and are now hard-coded.

I would like the formulas within A2:AR2 to populate from column 29 downwards, however I don't want to link to a row number asthis will continue to change.

[Norie]

You can't use AutoFill for that

Please Login or Register  to view this content.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.