Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.35 seconds.

  1. Replies
    1
    Views
    73

    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)
  2. Replies
    10
    Views
    124

    Re: VBA filling loop

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

    Re: VBA filling loop

    11-19 ON, 23-24 ON, 26 ON, other remain blank
  4. Replies
    10
    Views
    124

    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
  5. Replies
    10
    Views
    124

    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...
  6. 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
  7. Replies
    3
    Views
    89

    Re: Net Working Days

    This should give you the next Monday

    : =A2+(7-WEEKDAY(A2,2)+1),
  8. 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
  9. 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
  10. 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
  11. Replies
    6
    Views
    36

    Re: FIND returning #VALUE! error

    are those hardspaces from a download, maybe a different acsii code
  12. Replies
    2
    Views
    75

    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...
  13. 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
  14. Replies
    10
    Views
    265

    Re: Date , time formula

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

    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
  16. Replies
    10
    Views
    265

    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
  17. Replies
    10
    Views
    265

    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...
  18. 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
  19. 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
  20. 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"
  21. 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
  22. 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
  23. Replies
    6
    Views
    161

    Re: Sub is this possible

    Thank you, I didn't know what to search for
  24. 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...
  25. Replies
    2
    Views
    104

    Re: Unusual VBA Not Responding Issue

    try before that DoEvents, give the code a short breathing space before trying something new
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4