|Subject:||Copy a formula down in a macro|
|Date:||Sun, 4 Jun 2006|
I have information in column A and I wish to write a macro that:
1. Populates cell B2 with a VLOOKUP formula
2. The macro is then to copy the above formula down to the last active cell
in column A
I have tried so many things that I am in a bid of a muddle. Any suggestions
will be very welcome.