Can`t work out why my Range on a workbook worksheet says = Nothing

[Darren Smith]

The code below has this code saying = Nothing?

 Set PLDataRange = PL.Range("A13:P" & LastRow)

??

Private Sub Up_Date_Prices_Click()


    
Application.ScreenUpdating = False
    
        Dim SrcOpen As Workbook
        Dim Des As Workbook
        Dim JCM As Worksheet
        Dim PL As Worksheet
        Dim FilePath As String
        Dim Filename As String
        Dim PLDataRange As Range
        Dim LastRow As Long

        FilePath = "\\TGS-SRV01\Share\ShopFloor\PRODUCTION\PURCHASING\"
        Filename = "TGS Group Inventory Sheet - Main.xlsx"
    
       
      
        Set SrcOpen = Workbooks.Open(FilePath & Filename)
        Set PL = SrcOpen.Worksheets("Part List")
        LastRow = PL.Cells(PL.Rows.Count, "A").End(xlUp).row
        Set PLDataRange = PL.Range("A13:P" & LastRow)
        Windows("TGS Group Inventory Sheet - Main.xlsx").Visible = True
       
        Set Des = Workbooks("Automated Cardworker.xlsm")
        Set JCM = Des.Worksheets("Job Card Master")
  

        JCM.Range("O15").Value = Application.WorksheetFunction.VLookup(JCM.Range("D15"), PLDataRange, 16, 0)

      
      
      Application.DisplayAlerts = False
      
       SrcOpen.Close
      
      
      Application.DisplayAlerts = True
            
      Application.ScreenUpdating = True


          End Sub

 

[RoryA]

It will be Nothing until that code line has run - how are you testing it? If you're hovering over it while the line is highlighted as you step through, then it hasn't run yet.

 

[RoryA]

Also:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Darren Smith]

I ran the whole code but it still says = Nothing.
Also if I hit F8 it jumps the code?

 

[RoryA]

And the cross-posting links please?

 

[Darren Smith]

Sorry here you go
Trying to open workbook then use VLookup to find data then close workbook | MrExcel Message Board

 

[RoryA]

You have posted this question on at least one other forum. That is what I am referring to.

 

[Darren Smith]

Ok here you go
excel - My Range on Vlookup source worksheet says Nothing - Stack Overflow

 

[RoryA]

Thank you.

If you've run the whole code, then the variable will be nothing because it has gone out of scope. Are you actually having a problem with the code and, if so, what is it specifically?

 

[Darren Smith]

My problem with the code is when I press the button to run it finds the Workbook & opens it. But it can`t seem to open the Worksheet to Vlookup in?
I have added Debug Print to the Worksheet code but it shows Nothing?
When you say "Gone out of Scope" what do you mean?