View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NDBC NDBC is offline
external usenet poster
 
Posts: 204
Default Select range using row and column number addresses

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