Macro Help!!

[siasarma]

I am trying to create a Macro to Select all the cells in B:G And assign them the range name "List." But my macro won't work...I was wondering if somebody could tell me if there is something wrong with my macro...here's what it looks like:

Sub MasterInventoryList()
'
' MasterInventoryList Macro
' Macro recorded 10/3/2008 by Josiah
'
'
Columns("B:G").Select
Application.Goto Reference:="List"
Range("A1").Select
End Sub

 

[VoG]

Try

Sub MasterInventoryList()
'
' MasterInventoryList Macro
' Macro recorded 10/3/2008 by Josiah
'
'
Columns("B:G").Name = "List"
End Sub

 

[SQUINENE]

I would use this:

ActiveWorkbook.Names.Add Name:="new", RefersToR1C1:="='Sheet1'!C2:C7"


"new" = the name of the range
'Sheet1' = the sheet i have it created on
"C2:C7" = Columns B to G


Is this what you were looking to do?

***********************************************************
Ha, nvm Columns("B:G").Name = "List" is much better

 

[siasarma]

Your awesome!!! Worked like a charm!!! What was the difference???