View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
StumpedAgain StumpedAgain is offline
external usenet poster
 
Posts: 192
Default How to use a range name in a macro

If you've already named the range you can simply use:

Range("myRange")

where myRange is your named range. If you want to assign a range to a name,
you can use:

Range("B1:C12").Name = "myRange"

Hope this helps!
--
-SA


"CompetiveLat" wrote:

Hello and thanks,

I need to know how to use a named range in a macro!!! - Help.

(This in order to delete easily a range of cells)