Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.34 seconds.

  1. Replies
    1
    Views
    151

    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,...
  2. Replies
    1
    Views
    76

    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)
  3. Replies
    10
    Views
    131

    Re: VBA filling loop

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

    Re: VBA filling loop

    11-19 ON, 23-24 ON, 26 ON, other remain blank
  5. Replies
    10
    Views
    131

    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
  6. Replies
    10
    Views
    131

    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...
  7. 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
  8. Replies
    3
    Views
    97

    Re: Net Working Days

    This should give you the next Monday

    : =A2+(7-WEEKDAY(A2,2)+1),
  9. Thread: Index Maybe?

    by mole999
    Replies
    5
    Views
    133

    Re: Index Maybe?

    you can create a macro book that is available when you load excel, so it should be possible to import the data once, trigger the macro to do the job you want and proceed
  10. Replies
    15
    Views
    234

    Re: Need proper formula for max

    to stop the top range changing use =IF(MAX(B$2:B4)=B2,MAX(B$2:B4),""), which locks the top line
  11. Replies
    15
    Views
    234

    Re: Need proper formula for max

    what version of excel are you using. Then I'm thinking utilis a named range for each group and you insert rows the range will extend and keep it constant
  12. Replies
    6
    Views
    38

    Re: FIND returning #VALUE! error

    are those hardspaces from a download, maybe a different acsii code
  13. Replies
    2
    Views
    78

    Re: Class Not Registered Error?

    1004 is usually not found. Activework to me means the current one, yet you have just opened and closed three, can you set focus on the one that should be active then refresh. either that or i am...
  14. Re: Saving a Workbook using a variable to name it

    Range G1 neds to be nominated which workbook you are using, also i left a backslash out
  15. Replies
    10
    Views
    267

    Re: Date , time formula

    in i =DATEVALUE(G4&"/"&H4&"/"&I4)-DATEVALUE(C4&"/"&D4&"/"&E4)
  16. Replies
    10
    Views
    267

    Re: Date , time formula

    where do you intend to store the result, are your dates actually dates or just text, what do you have as examples you can show
  17. Replies
    10
    Views
    267

    Re: Date , time formula

    so highest minus lowest give number of days, as a first starting point, into another column, then with a sumif or similar to add each group together
  18. Replies
    10
    Views
    267

    Re: Date , time formula

    are your dates in different fields. Then for the first one I would be looking at 5/7ths and if greater then 365 remove the approximate leave allocation. It would provide something rough with quite a...
  19. Re: File Format Not Valid; Document is corrupt- Need help repairing

    have a look at > https://www.repairmsexcel.com/download-excel-repair.php and see if the free version reports recoverable
  20. Replies
    6
    Views
    161

    Re: Sub is this possible

    Thank you for the research. I had started to implement a label by label identifier. It has shown some issues which have been corrected
  21. Re: Saving a Workbook using a variable to name it

    something like
    Dim NewName as String
    NewName = Range("G1")

    ActiveWorkbook.SaveAs Filename:="C:\Users\USER\New TestnTrade" & NewName & ".xlsm"
  22. Re: File Format Not Valid; Document is corrupt- Need help repairing

    if you can post the file to a free file share site then people can try
  23. Replies
    6
    Views
    161

    Re: Sub is this possible

    No need to take it back, having options is always useful. the single use sub identifier is what I am after, easy to comment out or in globally
  24. Replies
    6
    Views
    161

    Re: Sub is this possible

    Thank you, I didn't know what to search for
  25. Replies
    6
    Views
    161

    Sub is this possible

    I'm having a big problem with a set of routines (I won't explain them) Is it possible to call a routine from a Sub, and return the ID of the calling Sub (maybe its not worth doing) I want to list...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4