Copy a formula down in a macro

Giganews Newsgroups
Subject: Copy a formula down in a macro
Posted by:  Sal
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.

Thanks

Replies