|Do you have a range named "A"? If not, this line won't work:|
If you are trying to select and entire column, you would use:
For a smaller range, you might use Range("A1:A100").Select
BTW - you don't have to select a range to perform an action on it. The recorder adds a lot of fluff that should be cleaned up later.
Range("A1:A100").Formula = "....." works just as well and is more efficient.
In addition, your code for the formula won't work.
You have a typo - the ] after the second B:B
In addition, FormulaR1C1 won't work with the B:B reference.
The syntax would have to be one of these 2:
FormulaR1C1 = "=VLOOKUP(C,apples,2,0)"
Formula = "=VLOOKUP(B:B,apples,2,0)"
Finally, why do you want to apply this formula to an entire column? Is your dataset really that big?
Before we turn the 2nd wrench (re: Column C) please clarify the other issues.