Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.32 seconds.

  1. Re: imputbox change decimal value dot to comma

    Change this
    ValorND = Val(ValorND)Otherwise you're converting it to an integer
  2. Thread: Formula check

    by Fluff
    Replies
    10
    Views
    62

    Re: Formula check

    Have a look at Data Validation https://www.excel-easy.com/examples/drop-down-list.html
  3. Replies
    3
    Views
    17

    Re: Filter criteria assistance

    :banghead:

    Keep getting my logic mixed up, especially with <>
    brendanolear
    Ignore my code in post#2 & use Dante's in post#3
  4. Re: Commence macro from current (not absolute) cursor position

    Change both instances of the range with selection, the periodic table sheet will need to be the active sheet.
  5. Thread: Formula check

    by Fluff
    Replies
    10
    Views
    62

    Re: Formula check

    I'm afraid I don't understand, where is your dropdown menu & what type of drop down is it?
  6. Thread: Sumifs/Macro

    by Fluff
    Replies
    1
    Views
    17

    Re: Sumifs/Macro

    I have removed your email address from your post. Generally, you should NEVER post your email address to public user forums. Spam Bots patrol such forums on the internet looking for email...
  7. Re: Is it Possible to write a Match Formula with a Defined Name Range?

    Match does not give a count, it simply finds the first match.
  8. Re: Is it Possible to write a Match Formula with a Defined Name Range?

    Your named range needs to be a contiguous range, otherwise it won't work.
  9. Replies
    3
    Views
    21

    Re: Problem Cycling Through Worksheets VBA

    That entirely depends on the code located at
  10. Re: imputbox change decimal value dot to comma

    How about
    If InStr(1, resposta, ".") > 0 Then resposta = Replace(resposta, ".", ",")
  11. Re: object variable or with block variable not set

    Cheers :beerchug:
  12. Re: Data validation - dynamic and also dependent on a particular column

    Toadstool
    When using < or > symbols you need to add a space either side, otherwise the board thinks that you are posting HTML code.
  13. Thread: Formula check

    by Fluff
    Replies
    10
    Views
    62

    Re: Formula check

    Is your dropdown a Data Validation dropdown?
    If so what cell is it in?
  14. Re: Extracting data from within multiple square brackets

    You're welcome & thanks for the feedback.
    Have a good weekend yourself. Certainly looks like we've got the right weather
  15. Replies
    3
    Views
    17

    Re: Filter criteria assistance

    Try
    .AutoFilter 16, "<>East", xlOr, "<>West"
  16. Re: Commence macro from current (not absolute) cursor position

    Change
    Range("N26:N34")to
    Selection
  17. Re: object variable or with block variable not set

    You're welcome & thanks for the feedback.

    Please note post#3 for future reference.
  18. Replies
    1
    Views
    13

    Re: Calculating all numbers by name.

    Have a look at the SUMIF function. https://exceljet.net/excel-functions/excel-sumif-function
  19. Re: Extracting data from within multiple square brackets

    If you follow the first 4 steps here https://www.ablebits.com/office-addins-blog/2013/12/06/add-run-vba-macro-excel/ and save the workbook as macro enabled.

    Then in your worksheet you enter...
  20. Re: object variable or with block variable not set

    Cross posted https://www.excelforum.com/excel-programming-vba-macros/1287516-object-variable-or-with-block-variable-not-set.html#post5181984

    While we do not prohibit Cross-Posting on this site, we...
  21. Re: Copy cells (values & Formatting) from one worksheet to another.

    It should do exactly the same as your code.
  22. Re: Need help on VBA Excel to copy paste value

    Change this
    .Range(.Cells(2, "A"), .Cells(lr, "A")).Copy DestSh.Cells(2, "A")

    to
    DestSh.Range("A2:A" & lr).Value = .Range("A2:A" & lr).Value

    And the same thing for the other two columns
  23. Re: object variable or with block variable not set

    Hi & welcome to MrExcel.
    I suspect that this line
    Set foundRng = Folha10.Range("A2:A400").Find(NumRecibo)is not finding the value of NumRecibo and therefore foundRng is nothing
  24. Re: Copy cells (values & Formatting) from one worksheet to another.

    Hi & welcome to MrExcel.
    How about
    Sub Philnblanks()
    With Sheets("JUNK")
    .Cells.ClearContents

    Sheets("ONGOING!").Range("A1:T10").Copy
    .Range("A1").PasteSpecial...
  25. Re: [VB help needed] Copy mulit folder files to Destination based on excel

    Simply add the _ to the file name in col A so that it looks like 859_ or 859A_
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4