Marius Nielsen
New Member
I'm quite new to VBA and have a code which is not working correctly. Its working for a singel cell but not multiple cells selections.
Please note that selcted cells to be copied are merged cells so wonder if this is causing the issue.
Sub Main()
Call Nummber
Call Mail_ActiveSheet
Dim NextRow As Range
With Sheets('Database')
Set NextRow = .Cells(.Rows.Count, 2).End(xlUp).Offset(1, 0)
End With
ThisWorkbook.Sheets('Ocean Export FCL').Range('e6,e5,e2,e1,e3,e4,e7,t2,t3,t4,af4,t5,t6,af6,ad19,y27').Copy
NextRow.PasteSpecial Paste:=xlValues, Transpose:=True
Application.CutCopyMode = False
Set NextRow = Nothing
ThisWorkbook.Save
Application.Quit
End Sub
Any chance for some help on this issue ? Thanks in advance.
Please note that selcted cells to be copied are merged cells so wonder if this is causing the issue.
Sub Main()
Call Nummber
Call Mail_ActiveSheet
Dim NextRow As Range
With Sheets('Database')
Set NextRow = .Cells(.Rows.Count, 2).End(xlUp).Offset(1, 0)
End With
ThisWorkbook.Sheets('Ocean Export FCL').Range('e6,e5,e2,e1,e3,e4,e7,t2,t3,t4,af4,t5,t6,af6,ad19,y27').Copy
NextRow.PasteSpecial Paste:=xlValues, Transpose:=True
Application.CutCopyMode = False
Set NextRow = Nothing
ThisWorkbook.Save
Application.Quit
End Sub
Any chance for some help on this issue ? Thanks in advance.
The original elements before deep copying 1 2 3, 5 4 The new list of elements after deep copying 1 2 7, 5 4 The original elements after deep copying 1 2 3, 5 4 In the above example, the change made in the list did not effect in other lists, indicating the list is deep copied.
Copy And Paste 2 Things
![Fractions copy and paste Fractions copy and paste](https://user-images.githubusercontent.com/341801/32516503-03bab576-c41d-11e7-9b13-abafc3c9b137.png)
Copied 2 0 7 – Copy And Paste Everywhere Word
Debit & credit 2 6 3 – personal finance managers. As of Version: 0.7.3382.0, I still can't find a way to paste from the keyboard. #524 (comment) leads me to release v0.4.2382.0 which says: You can now bind Ctrl+C to copy and it’ll still send a literal ^C if you don’t have any text selected. Using Excel ( MS office 2010) would like to know how to take a snapshot or copy a highlighted section and paste it in yahoo mail body without losing data configuration. Want it to paste as it is exactly. I have used the camera option that will take a picture of the copied section and allow me.