Hi all
need a little help please. i'm using VB (but very very rusty) and i need to write a simple macro to cut and paste in excel.
the macro so far is:
Sub populate()
'
' populate Macro
' Macro recorded 09/02/2010 by
'
'
'select correct cell
Range("D6").Select
'enter lookup
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],'10'!C6:C7,2,0)"
'copy selection
Range("D6").Select
Selection.Copy
'paste first half
Range("D6:D10").Select
ActiveSheet.Paste
'paste second half
Range("D13:D17").Select
ActiveSheet.Paste
End Sub
but, what i want to do is paste the range along the sheet from column D to column CX (incrementing in 2's as i go along)..
so i would paste in D, then F, then H etc....
how do i do it? can i use a variable for the column and increment this in a loop or is there some other way??
thanks in advance