Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.32 seconds.

  1. Replies
    10
    Views
    71

    Re: VBA filling loop

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

    Re: VBA filling loop

    11-19 ON, 23-24 ON, 26 ON, other remain blank
  3. Replies
    10
    Views
    71

    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
  4. Replies
    10
    Views
    71

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

    Re: Net Working Days

    This should give you the next Monday

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

    by mole999
    Replies
    5
    Views
    131

    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
  8. 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
  9. 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
  10. Replies
    6
    Views
    35

    Re: FIND returning #VALUE! error

    are those hardspaces from a download, maybe a different acsii code
  11. 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...
  12. 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
  13. Replies
    10
    Views
    264

    Re: Date , time formula

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

    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
  15. Replies
    10
    Views
    264

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

    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...
  17. 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
  18. Replies
    6
    Views
    153

    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
  19. 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"
  20. 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
  21. Replies
    6
    Views
    153

    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
  22. Replies
    6
    Views
    153

    Re: Sub is this possible

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

    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...
  24. 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
  25. Thread: PDF to Excel

    by mole999
    Replies
    6
    Views
    239

    Re: PDF to Excel

    very much depends on how is was created, is it pictures as pdf rather than converted text
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4