I have the following code:

Selection.AutoFill Destination:=Range("AG2:AH20000"), Type:=xlFillDefault
I want to edit the code so that the the Range("AG2:AH20000") will be instead:

Range("AG2:AH (Count of Column A rows)")

However I'm not so sure how to accomplish this, any help would be appreciated.