Locals Watch Disappears; Program Crash

Jun 29, 2007

I'm in the process of writing/editing a macro, but after I run the macro once, the Expressions in the Locals Watch window disappear, and if I try to run it again it produces an "Excel has encountered an error and needs to close". The macro probably doesn't make much sense out-of-context, but perhaps there's a glaring error that's causing this. A guess - possibly related to the Error Handling in the vba? (1st time I've used this in a macro).

Option Explicit
Sub Compare()
Dim strNaspK As String
Dim strCtryK As String
Dim intCtryRev As Integer
Do Until ActiveCell. Offset(1, 0) = ""
ActiveCell.Offset(1, 0).Select
strNaspK = ActiveCell
strCtryK = ActiveCell.Offset(0, 2)
On Error Goto ErrJump:........................

Basically, I've got two sets of data on different sheets, with NASP ID and country being variables. Just trying to import the data from the 'Comparison' sheet, if both the NASP id and country matches that on the first sheet, established by the variables.

View 2 Replies


ADVERTISEMENT

Process Without Having The Program Crash

Feb 7, 2007

what excel can process without having the program crash. Our company is using an old dos program to store payroll information (don't ask -they won't change it). Anyway - I have the ability to use pervasive software to pull the information into excel.

The problem here - is that the information is stored line by line. And in order for me to get useful information out of it, I need to sort those lines by date and a task code.

Here's the formula I am using.

=(SUMPRODUCT(($I$2:$I$65536>=$D$2)*($I$2:$I$65536

View 9 Replies View Related

Range Not Appearing Correctly In Locals

Feb 21, 2014

I have the following code:

[Code] ........

HierLastRow shows as 165 in Locals which is correct. When I look at HierUID in Locals the Range is B2:B2 and not B2:B165. How can I make the Range set correctly?

View 2 Replies View Related

Using Locals Window For Object Variables

Jan 28, 2013

If I declare a variable i to be an integer and then initialise it say i=10, I can see its value in the locals window.

However, if I define myrng as range and set myrange = Cells(1,1), looking at the locals window for myrng brings up a whole wealth of information.

View 6 Replies View Related

Stop Watch

Feb 4, 2003

Can we use excel as a stop watch, with pause and continue menu? We are going to have a mini basketball tournament and I was assigned to be a timer. I want to impress my friend by using excel as a timer.

View 10 Replies View Related

Programatically Add Watches To The VBE Watch Window

Jan 18, 2010

I'm debugging a file that keeps crashing. Every time it crashes I have to reenter about 6 different watches in my VBE Watch Window. Is there any way to have my Workbook_Open() create the watches?

View 14 Replies View Related

Code To Watch For Cell Change

Jun 29, 2006

I'm trying to write a macro that will watch to see if there is change in a range of cells, and if the values of the cells change to preform a given action. I need to do it this way because I can't put a formula in some cells.

View 8 Replies View Related

Sport Stop Watch With Laps And Total

Nov 8, 2009

I have seen many threads about the stop watch but have problem to figure out which one will be best for me. I would like to create the stopwatch in excel where I can time single athlete (unlimited number) and check their splits/laps as well to get their total time. I would like to be able to take as many splits I want it. I need this to work in seconds.

AthleteSplit 1Split 2Split 3 Split 4Split 7Split 8Split 9TotalMichalGreg

View 9 Replies View Related

Watch Window Does Not Display All Collection Items

Jun 20, 2008

I have a collection with several thousand items. I added the collection to the Watch Window in the VBE editor, but the Watch Window only displays the first 256 items in the collection. Is it possible to view all items of a collection in the Watch Window?

View 3 Replies View Related

Result Arrives And Disappears

Feb 21, 2007

I begin in the Word of VBA. It's the first time I've a formula which seems necessitate VBA to be written down.

Before to try to execute my complicate macro, I've begun with simple tricks. But I've got a strange comportment of Excel :

I've the following Sub :

View 14 Replies View Related

Textbox Disappears When Filtered?

Jul 17, 2014

I have created an Excel spreadsheet with data. I froze the top row and added filters. This document will be used by numerous people, so I would like instructions for them on how to update the data on the same page as the data.

I put the text box off to the right of the data, but when the data is filtered, the text box is hidden along with the hidden rows.

Is there a way to have instructions to the right of the data that will not be hidden when applying filters? It does not have to be a text box but it does need to be on the same tab.

View 1 Replies View Related

Userform Disappears After Clicking No

Apr 3, 2007

i got the userform to popup when the workbook is open and the buttons work fine... only problem is when i click on a button, it will ask the user yes or no... if the user press yes, it performs the required macro without any problem... but when the user press no, not only it will close the question, but also closes the userform... I would like the 'no' to close the question but not the userform...

View 4 Replies View Related

Scroll Bar Disappears Clicking It

Sep 7, 2007

I have a chart that I just added some dynamic text boxes to. That is the text is linked to a cell so that the text is automatically updated.

I also have a scroll bar that is used to adjust one of the cells. However, now once I click on the scroll bar it just disappears. I can click on the space where it is located and it will appear for a split second. Also, if I scroll down in the worksheet and then back up over the scroll bar the image will be refreshed and I can see the scroll bar again.

I didn’t have this problem until I added the dynamic text boxes, it worked fine with static text boxes.

Does anyone have any idea how to get around this, or do I have to stick with the static text boxes?

View 5 Replies View Related

Autofilter Disappears When AdvancedFilter Used

Sep 26, 2007

I have an auto filter setup on some data. When I perform an advanced filter either in-place or to another location, the auto filter disappears. Is it supposed to be have like that? If so is there some sort of work around?

View 2 Replies View Related

Text Disappears When Word Wrap Is Used

Sep 7, 2005

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

View 14 Replies View Related

Userform Disappears When Loading Template

Feb 7, 2014

I made a template file with a userform included to enter data into a protected sheet at the command of a button. When I open the template, everything works fine. However, when I use a macro to create a new workbook and import the template to create a new sheet (or several) the userform suddenly disappears! The template is saved as macro-enabled and the new workbook is saved the same way. What am I missing that I'm loosing the userform??

View 9 Replies View Related

VBA: Pop-up Calendar Disappears When Script Stops

Oct 14, 2008

My Workbook contains the following macro in Sheet 1, which displays a pop-up calendar in L15 when that cell is selected:

Private Sub Calendar1_Click()
ActiveCell.Value = CDbl(Calendar1.Value)
ActiveCell.Select
Calendar1.Visible = False
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Application.Intersect(Range("L15"), Target) Is Nothing Then
Calendar1.Left = Target.Left + Target.Width - Calendar1.Width
Calendar1.Top = Target.Top + Target.Height
Calendar1.Visible = True
' select Today's date in the Calendar
Calendar1.Value = Date
ElseIf Calendar1.Visible Then Calendar1.Visible = False
End If
End Sub.........

View 9 Replies View Related

Data Validation List Default Value Disappears?

Dec 3, 2012

I have a large spreadsheet with many cells that have a drop down list using data validation. The list is a named range with no blanks. Most of the cells show the default I have set. However, sometimes when changes occur in cells next to one with a drop down list, the default value mysteriously disappears and the cell appears blank. The functioning of the drop down lists is intact, it's just that the cell appears blank.

View 5 Replies View Related

Data Validation Disappears When Re-opening Spreadsheet?

Aug 23, 2013

I add data validation into 4 columns and when i re-open the spread sheet after saving it, it clears all validation.

Although it clears the validation, the place where it gets the data from is still there. i have also unfroze panes and is still clearing data validation

Attached is the spread sheet. The data validation is in columns A, G, H and I on the 'unsourced' page and is getting the data frfom the 'Sheet1' Page.

View 2 Replies View Related

Excel 2013 :: Formula Disappears Once It Calculates?

Jul 17, 2013

using Office Professional Plus (2013). Within my spreadsheet, I have a series of progressive dates to be used in as a timeline. Ultimately, what I need to accomplish is that when I change one date, all the proceeding entries update according to my timeline criteria (in this case 3 weeks or 21 days). I created a SUM formula that worked but only calculated one time. Once the calculation completes, the cell drops the formula. I need this to be constant as the dates often change. How do I get the formula to maintain? Further more, is there a better method to accomplish the task at hand other than the SUM option?

View 7 Replies View Related

Inserted Picture Disappears After Losing Focus

Aug 22, 2008

I have the same problem as Paul C in the following post:

(Pictures disappearing)
"Hi not a VBA problem, but when i insert pictures or logos into my workbook they disappear, i can insert a picture close the workbook but when i re-open it the picture has gone, i have to click on where it should be to get the border to appear, the move it to get it to appear.

I have tried inserting BPMS, JPGS, GIFS, but i have the same problem with them all, I have used the bring forward command but still have the same problem, I have even tried re-installing Office 2003 and installing all the latest updates but still get the same problem, any ideas?"

I have tried:

- Tools > Options > View > Objects > Show All
- Changing macro security level
- disabling macro security in my antivirus

View 9 Replies View Related

Macro-created Formula Disappears Without Pattern

Mar 13, 2007

On a sheet, I have a Worksheet_change sub that checks if the cell changed is in column 1, 10, or 19 and if it is, then the six cells to its right are filled with formulas I need. All formulas work, except for one. I've checked over and over again and the formula itself works fine - the coding behind it is exactly what it's supposed to be.

But for some reason sometimes the formula isn't put into the cell. I haven't found any pattern yet with this problem. Even stranger is that the formula is identical to one in another column before (which is also entered by the macro) and the other one has never disappeared yet. I'm setting both formulas with the abc.FormulaR1C1 property (I don't use the abc.Formula property to avoid having to write three different formulas - one for each possible column change).

View 3 Replies View Related

Crash On Close

Oct 9, 2007

I have a file with about 30 sheets and a size of 14 meg. When the file is saved by using the save button it seems to save. When the file is closed the Microsoft crash message appears. The changes seem to save and if you choose not to have Excel attempt to repair the file everything seems fine.

The other odd behavior the file has that is if you run a for loop on any tab it takes about 3-4 minutes to run. If you copy the tab to another book and run the same code it runs in 3-4 seconds. Any ideas?

View 6 Replies View Related

Linking To Another Tab Causes To Crash

Nov 16, 2009

I have a multi-tabbed spreadsheet that keeps crashing when I try to set up a reference from one tab to another tab in the same spreadsheet (e.g., =Sheet2!B1) . The spreadsheet does NOT have any macros in it although my Personal.xls DOES have numerous macros that I have been using for over 6 years with no problems. In any ase, when I start Excel without loading personal.xls, so that NO macros are loaded, the spreadsheet still causes Excel to crash when I try to set up the reference to another tab.

View 9 Replies View Related

Excel 2007 :: Screen Gets Distorted And Data Disappears

Aug 12, 2014

Excel 2007. Basically, I'll be working in excel and all of a sudden, my screen sort of blurs; gets scramble like below. This only happens when using Excel.

Myscreen.PNG

View 4 Replies View Related

Formatting Gradually Disappears In Daily Updated Workbook?

Aug 22, 2013

I have a workbook I update from numerous sources every day. A few months ago I noticed some of my formatting started to disappear - a couple of borders were missing. a day or two later a couple of cells which had color were no longer colored. number formatting reverted to general so my percentages just showed up as decimals and my dollar values no longer had a $ or commas. Eventually - over the course of several weeks - all formatting in the document was completely gone. A couple of times throughout this process I tried replacing all the formatting, but as soon as I'd save the file, close it and open it back up whatever formatting related changes I had made would again disappear.

Eventually I went back a couple months and pulled an old file which still had its formatting and updated that instead. This worked fine... for about 2 months. three days ago I started noticing the same issues - a few borders disappeared in the file. two days ago a few more borders were gone and a couple of cells lost their color. yesterday and today it has gradually gotten worse again.

View 4 Replies View Related

Macro Button On Quick Access Toolbar Disappears

Apr 15, 2014

I have written a macro. The macro in question simply shows a user form. There is far more code within the user form itself. It is designed to automatically format a workbook.

I saved the macro as an .xlam add-in file to the default folder. I then added a button for the macro to my Quick Access Toolbar. This seemed to work great.

However, when I open a new file that I want to run the macro on, the button disappears. In fact, a 2nd Excel window opens up on my task bar. The original window still has the macro button, but the new window does not.

View 5 Replies View Related

Crash After Worksheet Calculate?

Apr 14, 2014

The situation is a Workbook_Activate macro is conflicting with a worksheet module which is a worksheet_calculate that also runs a macro when there is a query refresh from another book. How do I get the workbook activate macro to run before the worksheet one activates? Right now everything crashes.

View 1 Replies View Related

Crash On Print Preview

Mar 11, 2009

This file contains the printing options of a larger userform. But I am having problems with the print preview crashing.

I'd click one of the printing options on the userform, this would bring up the print preview of that sheet.

And when I try to "test" its stability by going crazy on the view next/ previous page on preview, it'd crash. This is especially when I've got the screenupdating set to false.

Just wondering if anyone else can varify the crash/ suggest what maybe its cause?

View 9 Replies View Related

Excel Crash When Run Loop

Jun 3, 2012

I have problems with my excel crashing all the time when I try to run my code. It seems to happen in a loop where I open a .txt file and pull data from it, then close it, and open the next one...

There are no error code, just a message that Excel has stopped working and it will be closed, and then it is forced to restart. Just a mess!

This is my loop code:

Code:
Option Explicit
Dim Desktop As String
Sub Open60only()
Desktop = CreateObject("WScript.Shell").SpecialFolders("Desktop") & Application.PathSeparator
Dim which_folder As String, which_file As String, which_string As String, tick As String
Dim lastrow As Long
Dim wb1 As Workbook, wb2 As Workbook

[code].....

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved