Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    121

    VBA is *not* empty

    This code works for empty cells

    How can I amend it to work when the cells in column C has a value of "No" for example?

    Many thanks

    Sub System_Check()
    Dim cell As Range, c As Range, cad...
  2. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    Re: IsEmpty VBA

    solved with


    Worksheets("report").Range("E1") = "Systems Closed : " & Left(cad, Len(cad) - 2)
  3. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    Re: IsEmpty VBA

    is there any way I can paste the result into a single cell on a worksheet?
    rather than the result appearing in the msgbox


    If cad <> "" Then
    MsgBox "Systems Closed : " & Left(cad,...
  4. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    Re: IsEmpty VBA

    Many thanks Dante - that works a treat.
  5. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    Re: IsEmpty VBA

    ideally what i need is at each possible time 7am / 8am and 8:30am check column C is still if any blank, if it is display a message box showing all of the systems that have not been checked.
    ...
  6. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    Re: IsEmpty VBA

    Foe time specific

    <time(8,15,0)
    IF(INDEX(Open,MATCH(A2,System,0)) greatertthan TIME(8,15,0) <time(8,15,0)
    then look through the data in column C and return any that are blank</time(8,15,0)...
  7. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    Re: IsEmpty VBA

    Can it list all the system that opened? rather than just one?

    is there any way to be more specific regarding the timing? for example if I was writing an IF statement it might go something like;
    ...
  8. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    Re: IsEmpty VBA

    Hi shg

    unfortunately that is looking at the incorrect range and doesn't return the desired result.

    It needs to look at Column C ensure there's no blanks then return a message box containing the...
  9. Thread: IsEmpty VBA

    by ireland87
    Replies
    15
    Views
    543

    IsEmpty VBA

    hello

    I'm looking at a scenario such as the below;

    I've defined names;
    A2:A6 = System
    B2:B6 = OpenTime
    C2:C6 = Checked

    The current time is 08:15
  10. Conditional Formatting based on current time

    Hi

    I need to have some conditional formatting based on the current time

    Say A1 contains 07:00

    I'd like the formatting to be green if 07:00
    Orange when its 07:15
    Red after 07:30
  11. Replies
    1
    Views
    141

    vba to filter based off two criteria

    Hi

    im trying to filter some data

    all the data is contained within "master" and the filtered results need to be in "filter"

    I want to have two criteria to filter with from within the "filter"...
  12. Replies
    4
    Views
    176

    Re: Help naming a sheet from a macro

    Heres the full macro if that helps?

    Sub ExportSummary()


    Application.ScreenUpdating = False


    Set range1 = ThisWorkbook.Sheets("Data FORM").Range("A7:H" & Range("A27").End(xlUp).Row)
    Set...
  13. Replies
    4
    Views
    176

    Re: Help naming a sheet from a macro

    Hi

    can it look for a workbook with a name_*.xml?

    for example:
    ActiveSheet.Name = Workbooks(Summary Form_*.xml).Sheets("Input1").Range("A2")

    Do i also need to put the full path of the...
  14. Replies
    4
    Views
    176

    Help naming a sheet from a macro

    Hi

    my macro currently creates a new sheet within another document called Analysis_v3.xlsm and gives it a name of yesterdays date

    Workbooks.Open Filename:="filepath Analysis_v3.xlsm"
    Sheets.Add...
  15. Replies
    5
    Views
    246

    Re: Index Match Query

    i've sorted it out

    thanks for your help
  16. Replies
    5
    Views
    246

    Re: Index Match Query

    If i combine some IF statements in B6 unfortunately it displays FALSE

    for example if B5 = =IF(INDEX(DailyTask,MATCH(E1,System,0))<>"N/A","Daily...
  17. Replies
    5
    Views
    246

    Re: Index Match Query

    Hi

    if this is in B5
    =IF(INDEX(DailyTask,MATCH(E1,System,0))<>"N/A","Daily Task",IF(INDEX(PostTask,MATCH(E1,System,0))<>"N/A","Post Task",IF(INDEX(MonthTask,MATCH(E1,System,0))<>"N/A","Monthly...
  18. Replies
    5
    Views
    246

    Index Match Query

    Hi

    I'm trying to have an index match or equivalent whereby in cell B5 in looks for a daily task then if there is one displays "Daily Task"

    In cell B6 it then needs to look for a Post Task or a...
  19. Replies
    1
    Views
    192

    Help with a logical test

    Hi

    i have a formula that returns the correct result
    =IF(ISNUMBER(MATCH(A2,V8:V13,0)),IF(A2=B2,"eombh","bh"),IF(A2=B2,"eom","normal"))

    A2 = a date
    V8:V13 is a column of dates

    however i want...
  20. Replies
    8
    Views
    343

    Re: Help make this formula more elegant

    can i somehow get another query in front of;

    =IF(ISNUMBER(MATCH(J2,N2:N7,0)),IF(J2=K2,"eombh","bh"),IF(J2=K2,"eom","normal"))

    to first look at system H2 then compare the possible bank holiday...
  21. Replies
    8
    Views
    343

    Re: Help make this formula more elegant

    Thank you very much! works a treat :)
  22. Replies
    8
    Views
    343

    Re: Help make this formula more elegant

    I wonder if anyone could simplify the first part of the formula which determines what is in cell G7
    ...
  23. Replies
    8
    Views
    343

    Re: Help make this formula more elegant

    Yeah that did the job nicely, many thanks
  24. Replies
    8
    Views
    343

    Help make this formula more elegant

    Hi

    I've got this formula which works correctly but is a bit long winded and has a few nested IF statements;
    ...
  25. Replies
    2
    Views
    144

    Re: Creating a graph with multiple series

    any ideas?
Results 1 to 25 of 50
Page 1 of 2 1 2