Setting Reference as dynamic range from inactive sheet

[cbutters]

Hello all I am hitting a brick wall. I am trying to create a reference based off of a dynamic range, however if the sheet is not active I keep getting an error for out of scope or application-defined or object-defined error. The dynamic range is made through special cells since the data often has rows and cells that are empty. I am creating 2 references so that I can do a conditional format to see the changes (has it's own issues with highlighting the empty cells) If I set the sheet to active, it works perfectly.. set sheet 2 to active and it fails... I'm pulling my hair out please help!

Sub SelectRange1()


With Worksheets("Table 1")
Dim LastRow As Long
Dim LastColumn As Long
Dim StartCell As Range

Set sht = Sheets("Table 1")
Set StartCell = Range("A1")

'Refresh UsedRange
  Sheets("Table 1").UsedRange

'Find Last Row and Column
  LastRow = StartCell.SpecialCells(xlCellTypeLastCell).Row
  LastColumn = StartCell.SpecialCells(xlCellTypeLastCell).Column

'Select Range
  sht.Range(StartCell, sht.Cells(LastRow, LastColumn)).Select
  Application.Goto Reference:="Sheet1Data"
End With

End Sub

Sub Macro2()

' conditional formatt to highlight unique
'
     Application.Goto Reference:="Sheet1Data"
    Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
        "=COUNTIF(Sheet2Data,A1)=0"
    Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
    With Selection.FormatConditions(1).Interior
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
    End With
    Selection.FormatConditions(1).StopIfTrue = False
    
    
End Sub