Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problems naming cells using VBA
Agreed, every cell will have different data that could be reference, hence they need to be named. The order could change hence I can't relay on default cell names, I want the value tied to the cell name.- SmeeZee
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Problems naming cells using VBA
What version are you using? Does it work to the completion of the loop? The name itself is just a test for another program.- SmeeZee
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Problems naming cells using VBA
this is fine, does this work though, as it does not for me: Sub does_it_work() For i = 65480 To 65536 With ActiveSheet ActiveWorkbook.Names.Add _ Name:="a_" & i, _ RefersTo:="=" & .Name & "!" & .Cells(i, "A").Address End With Next i end sub Basically I need to name...- SmeeZee
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Problems naming cells using VBA
Try running this code in Excel, you should find the first loop works fine, and the cells are named. The second loop fails, why? I have searched the internet but can't find anything on it. Sub name_those_cells() Dim i As Long Dim objRange As Range Cells(1, 2).Value = "started" For i = 1...- SmeeZee
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
