not working

  1. K

    VBA Break Link Loop not working

    We are using a script to open all files in a folder, breaks links and save the file into a new location. There are over 50 files in the folder that the script works on perfectly. We have about 10 files that are causing heartburn. The vba returns an error on this section of code: For Each...
  2. N

    Late Binding a Public Dictionary object does NOT work

    I found below code to VLookup with cell format, it works only when you add "Microsoft Scripting Runtime" library to the workbook's VBA Project (via. Tools > Add > References) However, to remove the need to add above library, I modified a part of the first code as below, but It Does Not Work...
  3. D

    Application.ScreenUpdating = False, Not Working, Posting Code

    Hello, I can't figure out why Application.ScreenUpdating is not working, the screen flickers every time (after entering data on G2). I tried to figure it out from other posts, but it seems different things work for different people so I'm showing the code I'm struggling with bellow. Please...
  4. L

    FollowHyperLink Issue

    I am using the following code to unhide a worksheet and navigate to it when I click a hyperlink. For some reason, this code will fail to execute for periods of time when I open my workbook, but not every time I open it. Sometimes it will start working again in 20 minutes (without me reopening...
  5. M

    VLOOKUP Formula works on one sheet but fails on second sheet

    Hello, I have a multi-page workbook. It is an Excel 2010 .xlsx version. I have a copy of a sheet I'm using for play/work and have a vlookup referring to a a named ranged in a second file that works fine on the original page, but on the copied sheet, the exact same vlookup formula cannot find...
  6. J

    Tab, Escape, and Enter keys not working sometimes in user form?

    I have a somewhat complex user form with text fields, combo boxes, check boxes, and radio buttons. Sometimes, about 40% of the time when the user form is opened and starts at the first text box, keyboard commands do not work. This means that Tab does not go to the next field, Enter does not...
  7. M

    VBA code working in one workbook but not another

    Hi I apologise if this has already been solved somewhere on this forum, however I am unable to find it. I have two workbooks in which I am trying to use the same code. In one it is working but in the other it is not. I am using Excel 2007. Here is the code: Option Explicit ' Developed by...
  8. J

    Find/Replace based on table NOT WORKING - in SOME cases? Not sure why....?

    Hello, the code below seems to break at the occurrence of the special character "_" on the headings with "TXN"?? Or that have "_" and "two_words" vs. a "word_number". Any thoughts why it cant handle that / how I can fix it? ORIGINAL DATA SET <tbody> DMC_1 NSN_1 Date Quantity Unit Price...
  9. P

    INDEX MATCH not working for some values extracted using MID.

    Hi, because of the way data outputs from our work system, I need to extract a cost code string, from a long accounting string. I've got one column in some data where the account strings are held. they all start with the same 7 characters. The cost code is then from the 8th character, for 7...
  10. D

    Reflection 5250 question - Unable to .getdisplaytext consistantly

    Hi Team, I need your quick assistance on the below. I am sure it will be an easy one for you guys. I am initiating a macro from excel which connects to reflection 5250 performing the task and retrieves certain information displayed on the screen back to excel. However one of the codes which I...
  11. D

    =COUNTIFS Not working correctly?

    Hey Guys, Im running into an issue with my =countifs formula it is as follows. Some how the total is off... =COUNTIFS('Nov-11-2015-'!N2:N748,"*B1*",'Nov-11-2015-'!J2:J748,"*Small*") =COUNTIFS('Nov-11-2015-'!N2:N748,"*B1*",'Nov-11-2015-'!J2:J748,"*Medium*")...
  12. B

    appactivate is not working

    hi, thanks for letting me join this community. i am very curious about vba, but my knowlwdge is very little. 1. i´d like someone to explain me why instruction APPACTIVATE doesn't work on my excel2013. 2. is this or is this not an excel2013 instruction? 3. my goal is to activate excel no matter...
  13. S

    Macros not working

    Hello, Please help . On my pc macros are not working. Though done all following operations. 1 - enabled all macros setting from trust setting. 2 - digitally signed macro project from vba certificate from microsoft tools [/IMG] 3.- create macro enabled file i.e .xlsm please help
  14. A

    VBA Count if function ("<")

    Hello, I am new to VBA. I have the following code Sub Backtest() Dim myRange As Range Dim a As Long Dim i As Long, j As Long Set myRange = Range("b3:b217") For i = 1 To myRange.Rows.Count Worksheets("backtesting").Range("b" & i + 2).Copy...
  15. S

    need VBA correction from Rick

    RE: http://www.mrexcel.com/forum/excel-questions/866959-begin-new-line-cell-when-key-words-entered.html#post4208838 Rick HELP please. I think we lost ability to connect after last post at the above link. After I tried the program with the test data it was working fine. But now that I am...
  16. T

    SumIF not pulling all numbers from referenced data

    I have a SUMIF that is pulling a 10 digit number (6100089103) there are 4 of these numbers that are very similar, replace the last number with 4, 5 and 6. My SumIF is Summing all 4 numbers even though they are not the full number I'm wanting it to pull. Here is my formula: This is a...
  17. X

    Help fixing a code

    Hey mr excel i'm atm working on this code: If Sheets("Counting").Range(i, "R").Value = Sheets("Overview 2014-4").Range("Q1").Value Then Sheets("Counting").Range("S:W").Row.Copy Destination:=Sheets("Overview 2014-4").Cells(Rows.Count, "Q").End(xlUp).Offset(1, 0) End If First part...
  18. X

    Why does this code not work?? VBA

    I have some trouble with this Code, and i don't know why it's not working?? If Sheets("Counting").Cells("R4").Value = "Amount 2014 - 4" Then Sheets("Counting").Range("S4:W4").Copy Destination:=Sheets("Overview 2014-4").Cells(Rows.Count, "Q").End(xlUp).Offset(1, 0) End If i get...
  19. A

    Auto save/ AutoRecover Working Inconsistently - please help

    Using Excel 2013. I have used the autosave function frequently. I know to go to File->Options->Save and enable. -Boxes for for "Save autorecovery" every 10 minutes and "Keep last autosaved version if I close without sending" are checked. -Autorecovery file location...
  20. J

    Slicer & Value filter not working (not retaining selected values)

    Hello, Although I've used this forum for years to help me out with several challenges, this will be the first time I actually post a question :) I'm using a PowerPivot table to run a dashboard for production data. In the dashboard are several slicers. The dashboard is has been successfully...

Some videos you may like

This Week's Hot Topics

Top