prompting user for macro parameter

[peacelittleone]

I have a macro that does some formatting.

I need to prompt the user at the beginning of the macro for the name of a data range.

I would like to pass the answer they provide as a parameter to a function in my macro.

Is there a way to create a message box at the beginning of the macro to solicit this input from the user?

TIA!!!

Heather.

[peacelittleone]

I was able to figure it out.

rangeName = Application.InputBox(Prompt:="Enter range name:", Title:="Range Name", Default:="", Type:=2)


H