No you can't do that, but you can pass the range to the macro, like

Call myMacro(Range("A1:A10")

....

Sub myMacro(Rng As Range)

Msgbox rng.Address

End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Adrix " wrote in message
...
hello
first of all my apologizes for allways posting questions instead of
solutions, but I m still too beginner in programming.

I create a macro that format a range . Is it possible to "give" the
range the power to call it. Let´s say it is possible what i want to do
is have the abillity to call it just like:

range("myrange").mymacro

I know it sounds silly but..

thank you in advance

Adrix


---
Message posted from http://www.ExcelForum.com/