-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
lolastrow
-
V
Sum array then pasting it in another workbook
The formula I have is the following: Inarr: Range("A1:J57") With Workbook("book.xlsx").Worksheet("All") loLastRow = .Cells(Rows.Count, 1).End(xlUp).Row + 1 .Range("A") & loLastRow) inarr(43, 7) So thats great for single cells. Now I have to take cells E13:E21 + E23:E31, sum them and then paste...- Vbanoob98
- Thread
- cells inarr range lolastrow sum workbook
- Replies: 1
- Forum: Excel Questions
-
V
Optimizing code to copy data from one workbook and paste in another
Hello everyone, Here is the code I have so far: Sub ValuePaste() Dim loLastRow as Long ThisWorkbook.ActiveSheet.Range("E7").Copy With Workbooks("name.xlsx").Worksheets("fees") loLastRow = .Cells(Rows.Count, 6).End(xlUp).Row + 1 .Range("F" & loLastRow).PasteSpecial Paste:=xlPasteValues End...- Vbanoob98
- Thread
- code dim lolastrow optimizing valuepaste
- Replies: 3
- Forum: Excel Questions
-
R
Attendance append not working
Hello Everyone, Its been a while since my last visit. I have been working on the my VBA skills. I have a workbook with two sheets. I have written a code to append the data from one sheet to the other. But it is not working as desired. Any help or suggestion related to the issue is much...- roy00a4
- Thread
- .cellsrows.count 3.endxlup.row end lolastrow worksheetstemplate
- Replies: 3
- Forum: Excel Questions
