User Profile

Collapse

Profile Sidebar

Collapse
thummel1
thummel1
Last Activity: Jan 10 '17, 07:51 PM
Joined: Jan 10 '17
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • 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...
    See more | Go to post

    Leave a comment:


  • How 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...
    See more | Go to post
No activity results to display
Show More
Working...