Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing a list of defined named ranges
I have the following snippet of code
For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row Set REF = Cells(i, "a") Application.Goto Reference:=REF Exit Sub MsgBox ("Displaying " & Cells(i, "A")) Next i It's not going to the reference. What do I need to change? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing a list of defined named ranges
try removing Exit sub
or simpler?? For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row MsgBox ("Displaying " & Cells(i, "A")) Next i -- Don Guillett SalesAid Software "Barb Reinhardt" wrote in message ... I have the following snippet of code For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row Set REF = Cells(i, "a") Application.Goto Reference:=REF Exit Sub MsgBox ("Displaying " & Cells(i, "A")) Next i It's not going to the reference. What do I need to change? Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reviewing a list of defined named ranges
Oops, I should have removed the EXIT SUB. In column A, I have a named range.
I want to step through them one by one to view them. How do I do that? Thanks "Don Guillett" wrote: try removing Exit sub or simpler?? For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row MsgBox ("Displaying " & Cells(i, "A")) Next i -- Don Guillett SalesAid Software "Barb Reinhardt" wrote in message ... I have the following snippet of code For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row Set REF = Cells(i, "a") Application.Goto Reference:=REF Exit Sub MsgBox ("Displaying " & Cells(i, "A")) Next i It's not going to the reference. What do I need to change? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create new list with defined ranges | Excel Worksheet Functions | |||
Create new list with defined ranges | Excel Worksheet Functions | |||
VBA Script to Print several named ranges to PDF with cell-defined filenames | Excel Programming | |||
Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
ADO - recordset - closed excel workbook - know sheet name and cell name but no named ranges defined | Excel Programming |