No, I don't think we have for a few years. I did recently install a MS Add-in to Excel that uses a VB program, I thought that might be suspect. But I have an update on this. By modifying some of the code someone got it to work! Here is the new code:
Sub FPR_15_freeze_p anes()
[Dim Ws As Worksheet
Application.Scr eenUpdating = False
For Each Ws In Application.Act iveWorkbook.Wor ksheets
Ws.Activate
Range("G2").Sel ect...
User Profile
Collapse
-
thummel1 started a topic How to fix Compile Error: With object must be User-Defined Type, Object or Variantin Visual BasicHow to fix Compile Error: With object must be User-Defined Type, Object or Variant
Hi, this is my first post so hoping I do this right. I am trying to run a SUB in Microsoft Visual Basic for Applications, but I keep getting the following error: "Compile Error: With object must be User-Defined Type, Object or Variant." The SUB is attempting to freeze panes in many worksheets within an Excel workbook (Excel 2010). This is the remedy posted by Microsoft, but I am not sure what this means or what I need to do: "The...
No activity results to display
Show More
Leave a comment: