Creating formulas for rows with dynamic range

Hi all,
Nice easy one for you!

I'm copying a spreadsheet into another template. From there I want to run a macro to do various things. One of those things is to have the following formula for every cell in column B:

Please Login or Register  to view this content.

with the results displayed in say, column J.

However, column B is dynamic in the number of rows it may contain.

It's been a while since I've used VBA. I remember lines like 'Range("B65536").Select' and 'selection.End(xlUp)' but can't quite remember their context.

Any help would be appreciated.

Thanks.

Thanks for the quick reply!

However, I was hoping for a bit more help with the 'whole' code!!! It's been a while, and even then I was an extreme novice!

How do I go about inserting my formula in the OP? I need that formula for every row with data.....

Thanks again.

You sir, are a gentleman and a scholar.
Thanks very much.
Marked as SOLVED.