Hello,
Any help will be greatly appreciated !
I am having problems naming a range; actually all I need is to name a cell.
Here is the code I have
[code]
Sub NameCell()
Dim wb As Workbook
Dim rng As Range
Dim ws As Worksheet
Application.ScreenUpdating = False 'turn this off for the macro to run a little faster
For Each ws In Sheets
ws.Activate
ActiveSheet.Range("M1").Name = "Me"
'Range("M1").Name = "Me"
'Range("M2").Name = "Me2"
Next ws
Application.ScreenUpdating = True
End Sub
[\code]
Bookmarks