-
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.
lastrowcdr
-
N
How do I adjust the code so that I posts in CDR A3 rather than A2? Combines two worksheets into one worksheets posting values.
Trying to adjust code so that it posts .values on line A3 rather than A2... Thank you I adjusted 'first empty row from +1 to +2 but gives me a blank row between two sheets.... Sub CDRCombine() Application.ScreenUpdating = False Dim wsCDR As Worksheet Dim LastRowWs As Long...- NHagedorn
- Thread
- a.endxlup.row dim lastrowcdr startrowcdr ws.name
- Replies: 3
- Forum: Excel Questions
-
N
How do I get this VBA to paste values?
How do I adjust this VBA to paste values? Sub CDRCombine() Application.ScreenUpdating = False Dim wsCDR As Worksheet Dim LastRowWs As Long Dim LastRowCDR As Long Dim StartRowCDR As Long Set wsCDR = ThisWorkbook.Worksheets("CDR") LastRowCDR =...- NHagedorn
- Thread
- a.endxlup.row dim lastrowcdr startrowcdr ws.name
- Replies: 7
- Forum: Excel Questions
-
N
How Do I adjust VBA code to only combine 2 worksheets rather than all worksheets...
Trying to only combine sheet ("XPO" and "DDD"). I tried this exclusion If ws.Name <> "Stuff" And ws.Name <> "Data" And ws.Name <> "Next Injection" And ws.Name <> "Pull Through" And ws.Name <> "CDR" And ws.Name <> "Acct-W-Syr" And ws.Name <> "Pres-W-Syr" Then but I'm getting error and it is...- NHagedorn
- Thread
- a.endxlup.row dim lastrowcdr startrowcdr ws.name
- Replies: 2
- Forum: Excel Questions
-
N
VBA Not copy all of data from second page..... Please help
Sub Better() Application.ScreenUpdating = False Dim wsCDR As Worksheet Dim LastRowWs As Long Dim LastRowCDR As Long Dim StartRowCDR As Long Set wsCDR = ThisWorkbook.Worksheets("CDR") LastRowCDR = wsCDR.Cells(wsCDR.Rows.Count, "A").End(xlUp).Row + 1 wsCDR.Range("A2:AK" &...- NHagedorn
- Thread
- a.endxlup.row dim lastrowcdr long startrowcdr
- Replies: 1
- Forum: Excel Questions
