Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have used this very line of code successfully in other macros but here it errors out.
With cursor at the end of that line, Run DeBug - run to cursor gives me a yellow highlight. (NxtRow = Nothing) Thanks. Howard Option Explicit Sub Copy_All_Sheet_Sheet() Dim WS As Worksheet Dim NxtRow As Long Dim Nws As Long NxtRow = Cells(Rows.Count, "A").End(xlUp)(2).Row For Nws = 2 To ThisWorkbook.Worksheets.Count WS.UsedRange.Copy Sheets("Page 1").Range("A" & NxtRow) Next Nws End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Destination:=.Cells(.Rows.Count, "A").End(xlUp).Row + 1 | Excel Programming | |||
Count cells that contain "Y" in columnA IF contains"X" in columnB | Excel Worksheet Functions | |||
Cells(Rows.Count, "b").End(xlUp).Row | Excel Programming | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
"Clean Me" Macro is giving "#VALUE!" error in the Notes field. | Excel Programming |