Hello,
I have a current line of code (below) that works beginning at cell D5 and autofills to the end of data in col C. I am looking to make this code global to use in other macros.
How would I replace the references specific to D5:D and C with global references?
==================================
Code:
Dim MySelection As Range
Set MySelection = Application.InputBox(prompt:="Select one cell", Type:=8)
MySelection.Select
Selection.AutoFill Destination:=Range("D5:D" & Range("C" & Rows.Count).End(xlUp).row)
==================================
Thanks in advance.
I have a current line of code (below) that works beginning at cell D5 and autofills to the end of data in col C. I am looking to make this code global to use in other macros.
How would I replace the references specific to D5:D and C with global references?
==================================
Code:
Dim MySelection As Range
Set MySelection = Application.InputBox(prompt:="Select one cell", Type:=8)
MySelection.Select
Selection.AutoFill Destination:=Range("D5:D" & Range("C" & Rows.Count).End(xlUp).row)
==================================
Thanks in advance.