I'm using a macro to copy cells (2 columns and between 1 and 5 rows [19 - 23 on s/s]) from one workbook to another but if I use
Rows('2:2').Select
Selection.Insert Shift:=xlDown
then every cell in the inserted rows are populated.
this is what I currently have
Windows('agent master.xlsm').Activate
Range('B19:C23').Select
Selection.Copy
Windows('distribution master.xlsm').Activate
Sheets('L38').Select
Range('A2').Select
Selection.Insert Shift:=xlDown
Application.CutCopyMode = False
but that doesnt work either. It just gives me an empty cell in A2.
Ideas?
Copied – Copy And Paste Everywhere 1 1 58
Name: Copied – Copy and Paste Everywhere Version: 1.1.8 Mac Platform: Intel Includes: Pre-Ked OS version: OS X 10.10 or later Processor type(s) & speed: 64-bit processor Courtesy of HIOb and TNT Team Release Date: October 20, 2016 Whats New in Version 1.1.8 - Fixed background/automatic sync not working on some devices. Use Copied to save snippets of text, images and links quickly. Edit your clippings and organize them in lists. Access your clippings easily and use them in any app. Save text, links & images copied from any app as clippings. Copy clippings back to your clipboard and paste them into any app. Copied - Copy and Paste Everywhere for iPhone. Copied - Copy and Paste Everywhere for iPhone. Free Kevin Chang iOS Version 2.0.6 Full Specs. Visit Site External Download Site. Adobe xd cc v18 0 12. Windocd 1 6 esv.
