VBA codes using Named Ranges is not working since migration to O365

Jennifer Ford 0 Reputation points
2024-07-16T14:28:43.7766667+00:00

We recently migrated to O365 and we have several spreadsheets that are legacy items that transpose information from one sheet to another (info from input sheet to a table that is on another sheet for upload and is reconfigured to a different format) .

Up until last week all of them were working for everyone perfectly but now named ranges are causing this error message for some users but not all which seems odd. To our knowledge nothing was updated last week other than we did a server restart.

We have reviewed Macro security codes to align the users having trouble with the ones that are not having trouble. This has not made a difference unless there are other macro alignments not directly in excel that need to be done. The error message and code that it is getting stuck on is below:SnipImage (002)

Sub SummaryFillOut()

Range("DocType").value = DocType

Range("ShipTo").value = ShipTo

Range("CurrentStatus").value = CurrentStatus

Range("DocDate").value = DocDate

Range("InvcContact").value = InvcContact

Range("InvcDesc").value = InvcDesc

If Doc = 0 Then

    Range("Doc").value = "New"

Else

    Range("Doc").value = Doc

End If

**Range("Rev").value = Rev**

Range("PartnerCode").value = PartnerCode

If DueDate = 0 Then

    Range("DueDate").value = ""

Else

    Range("DueDate").value = DueDate

End If

Range("TermCode").value = TermCode

If Range("TermCode").value <> Range("TermsAccpacCode").value Then

    Range("TermCode").value = Range("TermsAccpacCode").value

End If



Range("InvcOther").value = InvcOther

Range("InvcSpecInst").value = InvcSpecInst



Call SummaryFillOutFormulas
End Sub

The other ranges are not causing an issue just the one bolded above relating to named code "Rev" in the same workbook which throws the error message.  The value of this range is "0" in most cases but it can have a value if a revision occurs on an existing document.  

Compared to the expertise online, I understand VBA and have problem solved successfully before but this does not seem to be consistent other than some ranges don't work for some users on some spreadsheets so any help with the debugging of this would be appreciated!

Thanks in advance for your review of this item.  JF

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,687 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,715 questions
{count} votes