VBA mixed references

I need a very simple macro which when activated copies the value in the b col in the current row. My problem is that I need to be able to activate the macro regardless of which cell is currently active so the col ref needs to be absolute, but the row ref needs to be relative. In formulae to be replicated to other cells it's very easy: $B1, $B2 etc, is it possible in VBA? if so how?

I've found a couple of things that mention mixed references but they all refer to one reference that's entirely relative working with another that's entirely absolute, I want one reference that has one of each element.

Thanks muchly.

not quite but

Please Login or Register  to view this content.

does the job.
Got the vast majority from yours obviously, thanks muchly.
Just so I'm sure I understand how it works, so I can replicate it for future projects that may be slightly different.
Is the

Please Login or Register  to view this content.

telling it to perform the

Please Login or Register  to view this content.

operation from the first column? or have I missed it?
Thanks again.