Using a Named Field for Autofill
Solved/Closed
excel987
Posts
3
Registration date
Tuesday June 11, 2019
Status
Member
Last seen
June 12, 2019
-
Jun 12, 2019 at 12:25 AM
excel987 Posts 3 Registration date Tuesday June 11, 2019 Status Member Last seen June 12, 2019 - Jun 12, 2019 at 10:52 AM
excel987 Posts 3 Registration date Tuesday June 11, 2019 Status Member Last seen June 12, 2019 - Jun 12, 2019 at 10:52 AM
Related:
- Using a Named Field for Autofill
- Clear autofill chrome - Guide
- Safari autofill - Guide
- Toggle field codes - Guide
- Names for your best friend on snap - Guide
- Opera autofill settings - Guide
1 response
You can initialize a variable, and use it. What is going to determine what that first value is? Take a look:
Firstrange="A1"
Selection.AutoFill Destination:=Range(Firstrange&":D" & Range("C" & Rows.Count).End(xlUp).Row), Type:=xlFillSeries
So as you see, we still have to initialize the variable with some usable range. Do you see the issue?
Firstrange="A1"
Selection.AutoFill Destination:=Range(Firstrange&":D" & Range("C" & Rows.Count).End(xlUp).Row), Type:=xlFillSeries
So as you see, we still have to initialize the variable with some usable range. Do you see the issue?
Jun 12, 2019 at 10:52 AM
Thank you so much for your help. Your code worked perfectly.