Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.32 seconds.

  1. Thread: PDF to Excel

    by mole999
    Replies
    6
    Views
    189

    Re: PDF to Excel

    very much depends on how is was created, is it pictures as pdf rather than converted text
  2. Re: If statement false value referencing same cell as formula cell

    maybe the iteration is set to zero or one
  3. Re: Can't use Excel - "There was a problem connecting to the server" error.

    my question was can you establish a working connection to the server reliably without using excel
  4. Re: Can't use Excel - "There was a problem connecting to the server" error.

    can you access your work server for other means, create the vpn first so you have a secure connection then get the excel ?
  5. Replies
    4
    Views
    220

    Re: Please help to identify unique values

    CF will show the duplicates
  6. Replies
    4
    Views
    172

    Re: columns question

    Its basically a list of staff and the ID (some numeric, some text), trying to make sure I see all variants (two or three is not uncommon) in the data and provide one very clean output
  7. Replies
    4
    Views
    172

    Re: columns question

    That could be it, I want to treat as individuals but search as a effective long list I will give that a work out, thank you
  8. Replies
    4
    Views
    172

    columns question

    Not sure what a good search term would be.
    I have a number of sets of data in a single range of columns. I'd like to have that data in multiple columns but treat as a VLOOKUP so C,J,O is that doable...
  9. Replies
    2
    Views
    80

    Re: VBA Automation Error

    have you done a full restart ?
  10. Replies
    12
    Views
    409

    Re: Conflicting codes?

    now you have a solution. would you have asked the question differently ?
  11. Replies
    12
    Views
    409

    Re: Conflicting codes?

    The Red envelop is explained at the bottom of the forum page, red for hot topic
  12. Replies
    1
    Views
    90

    Re: Sort a worksheet by Colour

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

    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 = _
    ...
  14. Replies
    1
    Views
    110

    Re: Make stop graph from having 0 values vba?

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

    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)
  16. Replies
    1
    Views
    103

    Re: IF statment MERGED Cells

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

    by mole999
    Replies
    15
    Views
    236

    Re: Null values

    are they from formulas ?
  18. 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
  19. Replies
    0
    Views
    117

    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...
  20. Replies
    13
    Views
    292

    Re: vbNullString Then

    change of machine, software change ?
  21. Replies
    12
    Views
    409

    Re: Conflicting codes?

    are they in the same macro
  22. 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
  23. Replies
    4
    Views
    74

    Re: Named Range Query

    https://www.mrexcel.com/forum/excel-questions/56616-namining-conventions-named-ranges.html
  24. 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...
  25. Replies
    1
    Views
    74

    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....
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4