Currently I copy and paste a range of cells one cell at a time because I can't get a range using a start and end variable (to be determined by an ealrier loop counting where the cells start and end) such as Range("A" & i : "A" & intLastRow).select.
Any ideas how i could copy the whole range, and then move it over and paste the whole thing, rather than coying each cell individually?
You can do it the way you want, your range just has the " in the wrong places and is missing a &
Range("A" & i : "A" & intLastRow).select.
Range("A" & i & ":A" & intLastRow).Select