I have a macro that I want to execute on the cells that I have selected on a
worksheet, that is, where 'Set myRng = Activesheet.Range(first selected cell:
last selected cell) or something like that. Any suggestions? Thanks in
advance

this may do what you want if you have a contiguous range of cells selected

Dim rng As Range
Set rng = Range(Selection.Address)

--


Gary


"Paputxi" wrote in message
...
I have a macro that I want to execute on the cells that I have selected on a
worksheet, that is, where 'Set myRng = Activesheet.Range(first selected cell:
last selected cell) or something like that. Any suggestions? Thanks in
advance

have you tried...

Set myRng = Selection
--
HTH...

Jim Thomlinson


"Paputxi" wrote:

I have a macro that I want to execute on the cells that I have selected on a
worksheet, that is, where 'Set myRng = Activesheet.Range(first selected cell:
last selected cell) or something like that. Any suggestions? Thanks in
advance

Here is a typical format:

Sub Macro1()
Dim r As Range
For Each r In Selection
r.Interior.ColorIndex = 6
Next
End Sub


You select the cells on the sheet and the macro "does something" to them.
--
Gary's Student


"Paputxi" wrote:

I have a macro that I want to execute on the cells that I have selected on a
worksheet, that is, where 'Set myRng = Activesheet.Range(first selected cell:
last selected cell) or something like that. Any suggestions? Thanks in
advance