Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code thus far. I want all of this information to be on the
same line but as of right now it buts it on two seperate lines. How can I combine the codes and have them com in on the same line. Sub copy_1_Values_PasteSpecial() Dim sourceRange As Range Dim destrange As Range Dim Lr As Long Application.ScreenUpdating = False Lr = LastRow(Sheets("Invoices")) + 1 Set sourceRange = Sheets("PO Form").Range("A44:G44") Set destrange = Sheets("Invoices").Range("A" & Lr) sourceRange.Copy destrange.PasteSpecial xlPasteValues, , False, False Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Sub copy_3_Values_PasteSpecial() Dim sourceRange As Range Dim destrange As Range Dim Lr As Long Application.ScreenUpdating = False Lr = LastRow(Sheets("Invoices")) + 1 Set sourceRange = Sheets("PO Form").Range("H44:H44") Set destrange = Sheets("Invoices").Range("H" & Lr) sourceRange.Copy destrange.PasteSpecial xlPasteFormulas, , False, False Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Function LastRow(sh As Worksheet) On Error Resume Next LastRow = sh.Cells.Find(What:="*", _ After:=sh.Range("A1"), _ Lookat:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious, _ MatchCase:=False).Row On Error GoTo 0 End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problems with copying and pasting dates from one worksheet to anot | Excel Discussion (Misc queries) | |||
Pasting problems | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Excel - Word: Problems copying/pasting shapes | Excel Programming | |||
Problems pasting images into Excel | Excel Discussion (Misc queries) |