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
- Mouse cursor not moving - Guide
- Data transmission cable - Guide
- Download facebook data - Guide
- How to insert picture in word without moving text - 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.
