When recording a macro to AutoFill all the cells, the recording specific a static range. I need to make this range dynamic. For instance, in one run my AutoFill range may need to be from C13:C30, while the next run could be from C13:C37. I took a shot at this and failed. Any ideas? My failed code is below. Thanks for any help!
Selection.AutoFill Destination:=Range(Selection, Selection.End(xlDown)).Select