Hi there
I have a maco written which operates on a relative reference from a specific cell; Activecell H5 will run the macro on cells B5:G5, and H10 will run the macro on cells B10:G10, etc.
The only problem is that I don't know how to run the macro from the cell!
I have the text "Find" in the relevant cells in Column H, and I'd like the user to be able to click/double-click on one of these H cells to run the macro on that row.
Can anyone please help?
Thanks!
Daniel
I have a maco written which operates on a relative reference from a specific cell; Activecell H5 will run the macro on cells B5:G5, and H10 will run the macro on cells B10:G10, etc.
The only problem is that I don't know how to run the macro from the cell!
I have the text "Find" in the relevant cells in Column H, and I'd like the user to be able to click/double-click on one of these H cells to run the macro on that row.
Can anyone please help?
Thanks!
Daniel