Public RowValueLong As Long Public Total_Acct As Long Public PTH As String Sub FDR_INFO() Dim oSys As Object Dim oSess As Object Dim oScreen As Object PTH = Trim(Sheets("FILE PATH").Range("B5").Value) Set oSys = GetObject(PTH) If oSys Is Nothing Then MsgBox ("There is no FDR attachment system in the specified location") Exit Sub End If 'GET ACCESS TO THE CURRENTLY ACTIVE SESSION... Set oSess = oSys.screen If oSess Is Nothing Then MsgBox ("No session available...stopping macro playback.") Exit Sub End If Total_Acct = WorksheetFunction.CountA(Sheets("PROCESSING").Range("B:B")) RowV