Hi
I am using
to add data to last row of column AB.
Please Login or Register to view this content.
The data in columns AB to AH have a border as seen here.
The question is what to add to above code to reset the block border so that it includes the pasted data.
Note that inserting a row is NOT an option as that would disrupt adjacent data.
Thanks
just paste into the offset then take the previous last row and copy pastespecial format
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Q:
your range you copy is going downwards
but your image shows paste going sideways
are you transposing but didnt include in code?
Oooops! Got me!
Please Login or Register to view this content.
something like this
*i've attached my test filePlease Login or Register to view this content.
Last edited by humdingaling; 02-22-2017 at 07:09 PM. Reason: ps if you dont need transpose just get rid of it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks