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

Yep, it is!
Something like that:

Sub t()
Dim r As Range
Dim c As Range
Set r = Application.InputBox("Select cell(s)", "Demo", , , , , , 8)
r.Select
For Each c In r.Cells
' do whatever u need
Next c
End Sub


(application before inputbox allows you to define the type of inputbox, and
when Type is 8, InputBox returns a Range object)


Does it help?
--
KR

V.


"mcphc" wrote:

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

Perfect!

"Vincnet." wrote:

Yep, it is!
Something like that:

Sub t()
Dim r As Range
Dim c As Range
Set r = Application.InputBox("Select cell(s)", "Demo", , , , , , 8)
r.Select
For Each c In r.Cells
' do whatever u need
Next c
End Sub


(application before inputbox allows you to define the type of inputbox, and
when Type is 8, InputBox returns a Range object)


Does it help?
--
KR

V.


"mcphc" wrote:

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