excel - Copy until the last piece of data -


Is it possible to choose a category to copy the last item? 

  sheet ("Design") Select range ("A1: C200"). 'My data runs only up to E-48 and IM leaves with 152 Blanks.   
 So now it copies from A1 to E 200, but how can I edit the above code, it only selects the last part of the data, which is my case Is E48 in? (This is the variable)  
 Thank you!  
 @jine  
 In my Excel sheet I have data running from A1-A18, B is empty and C1-C2. Now I want to copy all those cells which have a value.  with range ("A1") range (.cell (1, 1). End (xladown) .cell (20, 3) with copy expiration   
 It will copy everything from A1-C20, but I should look at the A1-A18 and C1-C2 only because they contain data but make it in a way It is necessary that when I have data in B or My limit, they will also be copied.  
 Is it perhaps a little obvious?  
 Copy / Paste State;  
 I am currently paste using this  
  apwd Selection. Paste special 'So does this format also make copies? 'In your case, do you mean I should do this?' Range (.seel (1, 1), end (xladown) .cel (20, 3)) Copy destination: = APPWD Selection. Paste Special    
 
 
 This works:  
  With range ("A1") category (.cel (1, 1). End (xladown) .seel (1, 5)) with copy ending   
 - Change the "5" if a different column is required.  
 In addition, I learned it harder:  Avoid Copy / Paste  if possible! Use the clipboard to copy and paste. When your code is running, other programs can be read by typing / on the clipboard, which can have wild, unexpected results. However, it is safe to copy to the target range on the same line, that is,  
  range (. (1, 1). End (XLdown). Cell (1, 5 )) .copy myDestinationRange   
 and this does not  
  range (.seel (1, 1). End (xladown). Cell (1, 5 )) .Short myDestinationRange.Paste   
 Later uses the clipboard, while the former does not.

Comments

Post a Comment