Moving Data
Closed
DonJuan692006
Posts
2
Registration date
Thursday May 26, 2016
Status
Member
Last seen
May 26, 2016
-
May 26, 2016 at 11:40 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 26, 2016 at 10:53 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - May 26, 2016 at 10:53 PM
Related:
- Moving Data
- Tmobile data check - Guide
- How to insert picture in word without moving text - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Transfer data from one excel worksheet to another automatically - Guide
2 responses
Just looking at a quick glance, I don't think your RANGE() is correct:
Typically, Range is defined by a NAME. Set the second range up as another variable, initialized as a range.
Like so:
Give that a try!
Range("E2", Range("E" & Rows.Count).End(xlUp))
Typically, Range is defined by a NAME. Set the second range up as another variable, initialized as a range.
Like so:
dim Rangx as Range
Rangx="E"&Rows.count
Range("E2",Rangx).End(xlUp).row
Give that a try!
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
May 26, 2016 at 10:53 PM
May 26, 2016 at 10:53 PM
Greetings Gentlemen,
Just wondering Ryan, is "Day Staff" your Master (or Input) sheet? Is it defined in the Project Explorer as Sheet1? (Project Explorer lists all the sheets to the left of the code field in the code Module).
If "Day Staff" is your Input sheet and it is defined as sheet1, then it is your Active Sheet, so:-
- Remove "Day Staff" from the array (ar), lines 6 & 7.
- Add quotation marks around the second part of the array: i.e. "Section 1", "Section 2" etc. so that it is the same as the first part of the array. This will ensure that Excel recognises this part of the array as Alphanumeric text.
- Change "E2" in line 14 to "E1" as you need to filter on the headings and not the first row of data which I assume starts on row 2 (other wise the offset(1) in line 16 will ignore your first row of data).
I reckon that should sort it out for you.
Cheerio,
vcoolio.
Just wondering Ryan, is "Day Staff" your Master (or Input) sheet? Is it defined in the Project Explorer as Sheet1? (Project Explorer lists all the sheets to the left of the code field in the code Module).
If "Day Staff" is your Input sheet and it is defined as sheet1, then it is your Active Sheet, so:-
- Remove "Day Staff" from the array (ar), lines 6 & 7.
- Add quotation marks around the second part of the array: i.e. "Section 1", "Section 2" etc. so that it is the same as the first part of the array. This will ensure that Excel recognises this part of the array as Alphanumeric text.
- Change "E2" in line 14 to "E1" as you need to filter on the headings and not the first row of data which I assume starts on row 2 (other wise the offset(1) in line 16 will ignore your first row of data).
I reckon that should sort it out for you.
Cheerio,
vcoolio.