And there's another reason to post a sample workbook.

Copy your sheet to a new workbook.
Close your original workbook.

With the new workbook, satisfy the assumption that were made, then:

Alt + F11 to bring up the Visual Basic for Applications Environment.
From menu bar click insert > Module
Paste the code into the pane that opens on the right.
Upper right corner X to close the VBA environment.
Save this workbook as a .xlsm (macro enabled file)

Alt + F8 brings up the Macro Dialogue box
Select the macro named test (will be the only one)
click run.

If that doesn't work, I'm afraid you'll need to break down and post a workbook.

PS: Please don't quote whole posts. Thanks