Use Specific cells as arguments in macros

Hi there,

My understanding of macro arguments is limited, so let me lay out what I want to do.

I want to make a function with an argument CopyAndPasteAsValue(Cell), where I can call the macro CopyandPasteAsValue(Cell) to whatever cell I need.

I plan on using this macro for multiple things, so I figured it would be better to write a macro with an argument that I can call, rather than write every specific function over and over.

Can I get some help with the architecture for this?

1. How should I declare this macro?

2. How do I use the specific Cell argument in the macro?

3. How should I call this macro from other macros?

Thanks for the help y'all. Always enjoy hearing your inputs.

Your Sub is called CopyAndPasteAsValue, which means you need a place to copy from and a place to copy to. But you only have one cell as an argument. Is that the source or destination? And what is the other one?

Here is an example that may give you enough information.

This sub will copy from Cell and paste to whatever is the active cell selected by the user at the time this is called.

Please Login or Register  to view this content.

Here is an example of how you can call it:

Please Login or Register  to view this content.

For a more specific answer, provide more details about what you are doing.