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:
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges.
- My contacts list names - Guide
- Count names in excel - Guide
- Monk names wow - Guide
- How to insert at the rate in laptop - Guide
- Where is the insert key on a laptop - 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.