Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.35 seconds.

  1. Thread: Formula Help

    by mole999
    Replies
    1
    Views
    46

    Re: Formula Help

    =(B36+(99*B45))-(b49/4)
    =(B37+B52)-B49
    =(B38+((99*B45)*52))-(b49/12)

    PEDMAS or BODMAS
  2. Replies
    2
    Views
    170

    Re: Lottery verification

    if you look at lottery odds it becomes apparent your wins are pure chance, once you cover off every potential number set you will win all the prizes but the more winners the less the return
  3. Re: Enable Microsoft Scripting Runtime permanantly

    you should really start a new thread, but i will ask what version of excel do you have, and does that file exist at that location
  4. Replies
    3
    Views
    253

    Re: VBA - too many line continuations

    never tried it with commandtext
    its possible to split the bits out and ultimately reassemble, i build in sql then convert to strings for excel
  5. Replies
    3
    Views
    160

    Re: ChDir path problem

    if you
    Dim test as string
    Test = FilePath & "\ " & InvNum

    debug print Test as step through to that with F8 and see if it looks right
  6. Replies
    3
    Views
    253

    Re: VBA - too many line continuations

    if you wrap each line like
    varname1 = ""
    varname1 = varname1 & "a " & vbCrLf
    varname1 = varname1 & "b " & vbCrLf
    varname1 = varname1 & "c"

    I use > http://www.dpriver.com/pp/sqlformat.htm set...
  7. Replies
    3
    Views
    98

    Re: Stop picture flashing as resized.

    MS Programs were all built by someone else originally, so their VB is different and whilst MS laid common controls on the face, they all react differently. Colour is part of the common display...
  8. Replies
    3
    Views
    98

    Re: Stop picture flashing as resized.

    maybe as simple as application.screenupdating = false

    Though images will rely on what your graphics processor can deal with, and you on screen colours, if you use 64bit colour compared to 16bit...
  9. Thread: VBA help

    by mole999
    Replies
    13
    Views
    275

    Re: VBA help

    Range("A1").Select
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$S$20000").AutoFilter Field:=1, Criteria1:="Yes"

    Range(Selection, Selection.End(xlDown)).Select
    Selection.Delete...
  10. Thread: VBA help

    by mole999
    Replies
    13
    Views
    275

    Re: VBA help

    thats why you filter on yes, the code wont care what line it is
  11. Thread: VBA help

    by mole999
    Replies
    13
    Views
    275

    Re: VBA help

    record the action

    apply filter on A for yes

    select the rows and delete

    then it can be tidied
  12. Thread: Overpass API

    by mole999
    Replies
    6
    Views
    253

    Re: Overpass API

    Thak you very much, I have currently zero knowledge in this area so lots of pitfalls for me to navigate, though knowing iy is possible is very supportive
  13. Re: path can't find if the path is in network

    so is it fixed by taking the extra spaces out ?
  14. Re: path can't find if the path is in network

    is it supposed to look like two spaces \ \ rather than \\ can you get that as a path and copy from what works straight into the vba
  15. Re: copying conditional formatting to different sheet

    try paste > values the paste > format. I've not seen a way to do it first time
  16. Thread: Overpass API

    by mole999
    Replies
    6
    Views
    253

    Re: Overpass API

    input is currently easting / northing which I can get converted to Lat/Long, and then I need the road speed associated with the location as mph. ultimately I would want a UDF that would do the...
  17. Thread: Overpass API

    by mole999
    Replies
    6
    Views
    253

    Overpass API

    Anyone with experience using APIs or this one specifically. I have 92K locations stored with Easting / Northing. The API suggests that it has Road Speed for a large proportion of the road network...
  18. Replies
    1
    Views
    776

    Re: The HDD from the old PC

    The basic design is that the data should not be recoverable by non admin, and that the disk would have been known on the domain for admin recovery. Defeats the object if the encryption doesn't hold,...
  19. Replies
    1
    Views
    114

    Re: Need help! Lookup function

    Have you tried a pivot table, vlookup will only return the first value of date (when looked for on its own)
  20. Replies
    10
    Views
    166

    Re: VBA filling loop

    Thany you both.Blindingly quick, apart from a few initial stumbles whilst testing
  21. Replies
    10
    Views
    166

    Re: VBA filling loop

    11-19 ON, 23-24 ON, 26 ON, other remain blank
  22. Replies
    10
    Views
    166

    Re: VBA filling loop

    sort of, need to fill down from ON to the OFF, then find the next ON and do again to the end of 90000
  23. Replies
    10
    Views
    166

    VBA filling loop

    I have a doc with 90000 rows. I need to visualise a status.

    I.e row 10 has on, then row 20 has off, so 11 to 20 have the ON flag and is visible.

    trying to do this manually and it is taking for...
  24. Re: Macro execution via the RIBBON has stopped.

    I will presume you have done a full computer shutdown and restart, and that in the options, the Trust centre still allows macros
  25. Replies
    3
    Views
    118

    Re: Net Working Days

    This should give you the next Monday

    : =A2+(7-WEEKDAY(A2,2)+1),
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4