Help with .Value

[judgejustin]

I have used .Value many times I can't figure out what I have done wrong here but it is not putting the value in. Below is my code. Also it's part of a larger code but nothing that should be interfearing with this. Any help???

Dim myValue As Variant
 myValue = InputBox("Enter Tax Roll Sequence Number")
Workbooks.Open Filename:=sPath & "Electronic CUS Appraisal Report TEMPLATE.xlsm", UpdateLinks:=True
 With Sheets("Parcel Specific Sheet").Range("B9").Value = myValue

 

[Fluff]

Get rid of the word "With"

 

[judgejustin]

Thank YOU!!!!

 

[Fluff]

You're welcome & thanks for the feedback.