Search:

Type: Posts; User: mole999; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.32 seconds.

  1. Replies
    1
    Views
    44

    Re: Sort a worksheet by Colour

    I think from 2007 you can sort by colour, I'm in 2013 and can't see backwards
  2. Replies
    2
    Views
    47

    Re: Problem deleting rows in VB

    the formula should be like this > =IF(OR(K1<>"DUB*",K1<>"LMK*",K1<>"ORK*"),1,0) I
    think
    ActiveCell.FormulaR1C1 = _
    ...
  3. Re: Make stop graph from having 0 values vba?

    did you try #N/A as your null value ?
  4. Replies
    2
    Views
    115

    Re: Excel features no longer working

    has it been accessed by anyone using a trial or not legitimate software package. Obvious thing to do is a full shutdown, then restart (which I would hope has already been tried)
  5. Replies
    1
    Views
    81

    Re: IF statment MERGED Cells

    record the merging as a macro, then you can see how it would be constructed
  6. Thread: Null values

    by mole999
    Replies
    15
    Views
    172

    Re: Null values

    are they from formulas ?
  7. Re: Excel File Size Question - Why is my file 36Mb with minimal Data in it? - Excel 2016

    ASAP utilities (freeware unless you want to buy it) will aim to recover over selected and stored ranges, you can get rid of unused styles, and you can save a copy as Xlsb. the binary file is smaller
  8. Replies
    0
    Views
    74

    Scripting Dictionary

    I know these appear really fast, I have a worksheet that grows every day and currently 98% has to be looked up manually (basically a location, that then develops into postcode ad easting & northing...
  9. Replies
    13
    Views
    244

    Re: vbNullString Then

    change of machine, software change ?
  10. Replies
    7
    Views
    234

    Re: Conflicting codes?

    are they in the same macro
  11. Re: Macro Application.OnTime TimeValue doesnt run all the time

    maybe run the five minute macro and if it is 1am then trigger the 1am portion. I'm not clear in my head how I would make that happen, but only one macro loop running then
  12. Replies
    4
    Views
    46

    Re: Named Range Query

    https://www.mrexcel.com/forum/excel-questions/56616-namining-conventions-named-ranges.html
  13. Re: Macro Application.OnTime TimeValue doesnt run all the time

    Just reading this to myself assuming 1 a.m
    tim = Time()
    tim1 = TimeValue("01:00:00")
    limt = TimeValue("00:00:30")
    deltatim = Abs(tim - tim1)
    If deltatim < limt Then
    tim = 1am
    tim1 testing for...
  14. Replies
    1
    Views
    51

    Re: Advanced Graph options.

    Anything Chart related I tend to search here first > https://peltiertech.com/

    That said I think you might be able to fake the look, overlaying graphs of the same outline, to make them look as one....
  15. Re: How to create a stopwatch with pause function in VBA

    macros can be stopped, they can have a delay in operating set, you can't just toggle on and off though, they are designed to do a task.

    This could work for you from another site >...
  16. Re: A PivotTable Report cannot overlap another PivotTable Report

    your symptom is just that pivots over reaching another, maybe 20 is the number, its difficult to be precise
  17. Re: A PivotTable Report cannot overlap another PivotTable Report

    I usually put 5-10 extra columns between each and that often solves the issue, its just they have to expand before they contract back to normal
  18. Replies
    3
    Views
    53

    Re: Pivot tables Issues

    the code is like




    Sub macro2()

    Dim i As Long

    Application.DisplayAlerts = False
  19. Replies
    3
    Views
    53

    Re: Pivot tables Issues

    Drilling to detail creates a new sheet and does nothing more with formating

    There are a number of routines around that that can delete sheets name sheet when you close or change focus

    other...
  20. Replies
    4
    Views
    144

    Re: VBA stuck in a loop I can't get out of

    first thought is it is a worksheet change event, and that probably drives your endless loop
  21. Re: Creating a `PopUp Menu` using 'CommandBarPopup' what other methods are there? Context Menu.

    I haven't played with command bars. If the vab is already written then just point the right click menu to the VBA
  22. Re: Creating a `PopUp Menu` using 'CommandBarPopup' what other methods are there? Context Menu.

    it goes in the worksheet vba you want to use it on
  23. Re: Creating a `PopUp Menu` using 'CommandBarPopup' what other methods are there? Context Menu.

    Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
    Dim cBut As CommandBarButton
    Dim cBut2 As CommandBarButton
    Dim cBut3 As CommandBarButton

    On Error Resume...
  24. Re: Creating a `PopUp Menu` using 'CommandBarPopup' what other methods are there? Context Menu.

    I have a right click routine, where the options are shown as part of that menu
  25. Replies
    8
    Views
    223

    Re: Extract words from cells

    are the all the same format ?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4