Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative Position in VBA Array
I have the following code:
Function DDEUpdate() Dim colTimeStamp As String colTimeStamp = "I" varr = ThisWorkbook.LinkSources(xlOLELinks) For i = LBound(varr, 1) To UBound(varr, 1) If IsEmpty(ThisWorkbook.ActiveSheet.Range (colTimeStamp i).Value) Then ThisWorkbook.SetLinkOnData Name:=varr(i) Procedu="'MyLinkProc " & i & "'" Else: ThisWorkbook.SetLinkOnData Name:=varr(i) Procedu="" End If Next End Function The varr(i) returns the OLElink based on a sorted order and th Range(colTimeStamp & i) returns the value of i. How do I find the ro that varr(i) is referencing? Thanks, Joh -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to macro to relative position | Excel Discussion (Misc queries) | |||
Array to find relative position - is there a better way? | Excel Worksheet Functions | |||
Relative position of Employees | Excel Worksheet Functions | |||
Macro relative to button position | Excel Programming | |||
relative position in macro | Excel Programming |