Hi,
I am currently trying to run a macro that will copy a range of cells in my case F3:I50 from sheet Stopwatch and then paste them onto another sheet in a different folder.
Below is my VERY basic code which copies and pastes but with it currently it will just paste over the previous rather than move down and paste into the next blank box, can anyone help me add in "search for blank" aspect?
Thank you in advance!
Please Login or Register to view this content.
How aboutPlease Login or Register to view this content.
Hi ! Try this ‼
Replace your piece of code by this one :
PHP Code:V = [F13:L19].Address(External:=True)
With Workbooks.Open("S:\SEO Folder\SEO Trend Analysis\Team Totals.xlsx")
Range(V).Copy .Worksheets("Aidan H").Cells(Rows.Count, 1).End(xlUp)(2)
' .Close True
End With
Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !
Last edited by Marc L; 03-22-2018 at 10:36 AM. Reason: optimisation …
They both work! thank you!
I'm going to use fluff13's solution because I understand it more and therefore can manipulate it.
MarcL - I think you are way more advanced at this stuff than my brain and comprehend
Glad we could help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks