dim myRange as Range
Set myRange = Application.InputBox(prompt := "Sample", type := 8)

HTH
--
AP


"mcphc" a écrit dans le message de news:
...
I would like to write a macro that asks the user to select multiple cells
on
a sheet (i.e. D10,AK13,AG16,V19) using an InputBox or similar. Then I
would
like the macro to cycle through each of the cells using the cell contents
as
a string in some other statements.

Is this possible?

Thanks

Clayton