Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    2
    Views
    130

    Re: search and display rows

    below is a formula, i have assumed your table starts in column A and ends in AH, also the name of the sheet where your table is is Sheet1.
    ...
  2. Re: VBA warning message when specific drop down selection is made

    The below could work, give it a try in a test version of your workbook. Select the sheet you want this check on, right click on the name of the sheet at the bottom, press View Code and paste the...
  3. Re: Grasping data in the web: how to write in a calendar

    How are you "clicking" the search button? is this a public web page?
  4. Replies
    5
    Views
    242

    Re: Thisworkbook.activate does not work

    As above what =ODIN= said, but also what is WKBnew supposed to be as its not defined or set to anything?
  5. Thread: #value!

    by BarryL
    Replies
    4
    Views
    273

    Re: #value!

    what result do you want if its blank?

    possible solution : =IFERROR(IF(B16>0,B16*O10),"")

    note this will return FALSE if B16 was negative
  6. Re: Grasping data in the web: how to write in a calendar

    what if you change .Value to .innerText?
  7. Re: VBA loop to reconcile and delete entier rows

    if you are deleting in a For loop you will need to step backwards like below.

    can you paste your current code?



    For j = lastrow To 1 Step -1


    'if condition here then
  8. Thread: Debug help

    by BarryL
    Replies
    29
    Views
    1,136

    Re: Debug help

    i think im having problems with objects not being defined .

    I stripped it back and did a small test on the below and it worked, is the below what you expect the webpage to do?

    reference for...
  9. Thread: Debug help

    by BarryL
    Replies
    29
    Views
    1,136

    Re: Debug help

    when you step through it with F8, does it enter in the values into the boxes and submit the form at all?
  10. Replies
    4
    Views
    198

    Re: If Formula Error

    Brackets also need to be closed inside the formula not just on the end.
    ...
  11. Thread: Debug help

    by BarryL
    Replies
    29
    Views
    1,136

    Re: Debug help

    what line is it stopping on? whats the error you're getting?
  12. Replies
    2
    Views
    168

    Re: IE browsing and user field manipulation

    Are you sure they are ID's and not classes or names? can you post the HTML code? what error are you getting currently?
  13. Replies
    6
    Views
    245

    Re: Max amount within a range

    put this in C2 and drag down (with cntrl+shift+enter)

    =IFERROR(INDEX($A$2:$A$19, MATCH(0,COUNTIF(C$1:C1, $A$2:$A$19),0)),"")

    then in D2 put (with cntrl+shift+enter)
    ...
  14. Replies
    6
    Views
    245

    Re: Max amount within a range

    i dont know what type of Microsoft Office you have but if its like mine (2010) you can use the below (newer versions have a MAXIFS i think?)

    entered with ctrl+shift+enter...
  15. Replies
    2
    Views
    174

    Re: Conditional formatting with date

    greater than 180 days old yes?

    in the conditional formatting section select new rule, then "Use a formula to determine which cells to format", the enter the below formula

    <today()-180)...
  16. Re: I've entered too many arguments for function

    in all of your IFs you are providing logic, false values and true values. you cannot then add another IF to the end as you have run out of arguments.

    something like
    =
    IF(AND(D13<$A$5,...
  17. Re: VBA to select rows before today's date and paste as values

    firstly, "History" is a reserved name so not sure how you can have a sheet named this?

    secondly, are column A's data formulas or constants? if the formulas are dragged down past the point of the...
  18. Replies
    2
    Views
    164

    Re: Curly Brackets but not an array?

    The curly brackets in this case is an array for your criteria. Putting SUM prior to the COUNTIF allows the COUNTIF to perform its duties on all criteria within the curly brackets.

    For example, it...
  19. Replies
    2
    Views
    148

    Re: VB Code to resize an image

    It worked for me when i switched the width with the height. Can you try that?



    Sub GetPic()
    Dim fNameAndPath As Variant
    Dim img As Picture
    fNameAndPath =...
  20. Replies
    1
    Views
    244

    Re: COUNTIF date is in previous week

    Hi, Column BP are dates correct?

    I think the below will suffice.

    =COUNTIFS(BP:BP,">="&(TODAY()-7)-MOD((TODAY()-7)-2,7),BP:BP,"<="&TODAY()-7+(7-WEEKDAY(TODAY()-7,2)))
  21. Replies
    5
    Views
    1,968

    Re: VBA to run macro in another workbook

    now youve take the apostrophe out, it should be

    application.run "Refresh.xlsm!Refresh"

    If the file is open and you provide the full link it won't work.
  22. Replies
    8
    Views
    2,256

    Re: VBA - 'Sorry, we couldn't find'

    if Refresh.xlsm is already open it should be



    Sub openBk()


    Workbooks.Open "C:\Users\Stuart MacDonald\OneDrive - Cles\Order book\Project check.xlsx"
    Application.Run "Refresh.xlsm!Refresh"
  23. Replies
    3
    Views
    218

    Re: Debug.Prints nothing...

    your set should be to class name rather than tag name.

    the below code gives an output of :

    Previous Close16.17
    Open16.17
    Bid0.00
    Ask0.00
    Expire Date2018-11-23
    Day's Range16.17 - 16.17
  24. Re: Copying Data to Blank cells abovbe data in same Column

    Hi, does the below work for you?



    Sub test()
    Dim lr As Long, i As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    For i = lr To 1 Step -1
    If Range("A" & i).Value = "" Then...
  25. Thread: If(and( & n/a

    by BarryL
    Replies
    2
    Views
    98

    Re: If(and( & n/a

    Are you saying that if J12 = 4 & K12 = "N" then your formula is giving "5Y"??

    I copied your formula exactly and i think it should work. Do you by any chance have your calculation set to manual?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4