N
NDBC
I'm trying to select a range starting in a1 and finishing at a known row and
column number. I have tried this but am getting an error. Arow is the number
of rows down and MAxa is the number of columns across.
wb.Sheets("A Lap").Range("a1:" & Cells(ARow, MaxA)).Copy
wbNew.Sheets("Sheet1").Range("A1")
I'm guessing either cells is the wrong command or i'm using it incorrectly.
Thanks
column number. I have tried this but am getting an error. Arow is the number
of rows down and MAxa is the number of columns across.
wb.Sheets("A Lap").Range("a1:" & Cells(ARow, MaxA)).Copy
wbNew.Sheets("Sheet1").Range("A1")
I'm guessing either cells is the wrong command or i'm using it incorrectly.
Thanks