making autofill range dynamic
 

Hi. For the following code:

Range(Selection, Selection.End(xlDown)).Select
Selection.AutoFill Destination:=Range("A4:A11"), _
Type:=xlFillDefault

I am trying to figure out a way to make the Range not specify A4:A1
because each time the macro is run, it should go down a cell. Fo
instance, the next time it is run, the Range should read A4:A12. Ho
do I do that?

Thanks in advance for helping me out with this!

--
Message posted from http://www.ExcelForum.com