• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Corrupted file with VBA

David Evans

David Evans

Active Member
I have a model that appears to have become corrupted in some manner. If I open it and with Shift down to suppress the autoexec, i can see the VBA code, but none of the sheets appear - is there anything truly obvious I am missing here? Anyone seen anything similar?
 
Code: 
Sub CopyRange()
'This sub returns the main worksheet to its native, pristine, empty self ....

Dim Rng1 As Range, Rng2 As Range, Rng3 As Range
Application.ScreenUpdating = False
Set Rng1 = Worksheets("Blank Acct").Range("Blank_Data")
Set Rng2 = Worksheets("Summary").Range("A9")
Set Rng3 = Worksheets("Summary").Range("A2")

Rng1.Copy Rng2
Worksheets("Summary").Activate
Cells(2, 1) = ("Relationship")
Application.ScreenUpdating = True

End Sub

This *appears* to be the code that causes issues - anything really awful there? (whoa now - don't be putting the old man down!)
 
OK - the issue seems to be that somehow the workbook is Hidden - how it became hidden I have no idea, but that seems to be the problem .... Anyone seen this?
 
Aha! It is hidden because of a Pilot Error!
Who is the pilot? Moi!

I have a new question to pose, but will start another thread ...
 
You must log in or register to reply here.
Back
Top