vba - Writing Range in excel. -

colname = split(cells(, i).address, "$")(1) lastrow = .cells(.rows.count, colname).end(xlup).row ws.("?" & lastrow).copy ws1.cells(rows.count, "a").end(xlup).offset(1, 0) 

i number, converted column name. need range starting number 4 eg if =1, need range("a4" & lastrow). have lastrow , can , how make a4

dim ws worksheet dim row integer dim col integer row = 4 col = 1 range(cells(row, col), cells(lastrow, col)) ws.range(cells(row, col), cells(lastrow, col))