Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.29 seconds.

  1. Re: "Object doesn't support this property or method" -Help with VBA

    This line:


    If ActiveWorkbook.Sheets("Sheet2").Cell(3, X).Value <> "" Then[/code

    should be:

    [code]If ActiveWorkbook.Sheets("Sheet2").Cells(3, X).Value <> "" Then

    like the previous...
  2. Re: VBA, using variables for all stages of Vlookup, from a changing source sheet.

    It would be:


    Range("S3:S" & lastrow).FormulaR1C1 = "=IF(RC[-6]=""Y"",IFERROR(VLOOKUP(RC[-7],[" & ml.Name & "]list!C" & Addr8 & ":C" & pu & ",VLrng,0),""""),"""")"
  3. Re: VBA, using variables for all stages of Vlookup, from a changing source sheet.

    You need to concatenate in the column, but you actually want the column number, not letter, since you're using R1C1 formulas.
  4. Re: vba to skip corrupt files needed (Excel crashes when trying to open)

    You might try specifying the CorruptLoad:=xlextractdata (or xlrepairfile) argument for Workbooks.open.
  5. Replies
    4
    Views
    51

    Re: VLOOKUP vs INDEX-MATCH

    Then I'd suspect that you have something like leading or trailing spaces in one set of data and not the other, resulting in no match. Or you have calculation set to manual and filled the formula down...
  6. Replies
    4
    Views
    51

    Re: VLOOKUP vs INDEX-MATCH

    It won't make any difference, but the equivalent would be:

    =INDEX(G:G,MATCH(A2,D:D,0))

    I suspect you have a data type mismatch or leadingt/trailing spaces. Are you looking up data thast looks...
  7. Replies
    10
    Views
    13,099

    Re: Combine Text & VLOOKUP in a single cell

    No, that's not what you want. If you uncheck it, what error does the cell now show - #N/A?
  8. Replies
    2
    Views
    24

    Re: Turning vbmodeless on/off for userform

    I'd suggest avoiding the refedit altogether - see Jon's blog here: https://peltiertech.com/refedit-control-alternative/
  9. Re: Recording a long formula is splitting it and destroying it

    The macro recorder is flawed with long formulas - it seems to replace part of the actual formula string with the line continuation characters. I suggest you enter the formula into the first cell...
  10. Replies
    10
    Views
    13,099

    Re: Combine Text & VLOOKUP in a single cell

    At the bottom of the Advanced section of Excel options, do you by any chance have the 'Transition formula evaluation' options checked?
  11. Re: excel vba "On Error go to" while in an Autofilter procedure

    That's not really the point, I'm afraid. You need to post the links - eg:
    ...
  12. Re: excel vba "On Error go to" while in an Autofilter procedure

    Copy the web address(es) of your other post(s) into a new post here, please.
  13. Re: excel vba "On Error go to" while in an Autofilter procedure

    Please take a minute to read the forum rules on cross-posting, and then comply with them. Thank you. :)
  14. Replies
    2
    Views
    67

    Re: VBA - Centre all cells

    Welcome to the forum.

    Basically:


    With ActiveSheet.Cells
    .HorizontalAlignment = xlCenter
    .VerticalAlignment = xlCenter
    End With
  15. Replies
    12
    Views
    128

    Re: Output error with VBA

    Can you post that as a separate question please as it's not the same as the original issue here?
  16. Re: Trouble pasting VBA code, scrolling down post, typing

    It varies with versions of IE and I'm currently on a Mac anyway, but basically follow these instructions (but select rather than deselect the compatibility mode options):...
  17. Re: Excel cannot open the file because the format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file

    What exactly does the highlighted part mean?
  18. Re: Excel VBA Code to delete slides in PowerPoint

    Glad to help. :)
  19. Re: Excel cannot open the file because the format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file

    Unless you have a reason that you need that workbook kept open, I suggest you use SaveAs and specify the file format instead of using SaveCopyAs. See: http://www.rondebruin.nl/win/s5/win001.htm
  20. Re: Excel cannot open the file because the format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file

    SaveCopyAs can't change the format of a workbook, but does save a copy (obviously). How is DestinWB created?
  21. Re: Excel cannot open the file because the format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file

    No, I'm interested in any bit that has SaveAs in it.
  22. Re: Excel cannot open the file because the format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file

    Like I said, perhaps the defaults are different. If your code is just something like:


    activeworkbook.saveas filename

    it will use whatever the default save format is. If that's say xls and...
  23. Re: Excel VBA Code to delete slides in PowerPoint

    I'd use another variable for the presentation:


    Sub PPT_Part()


    Dim FileName As String
    Dim PowerPointApp As PowerPoint.Application
    Dim A1, A2 As Integer
  24. Replies
    12
    Views
    128

    Re: Output error with VBA

    I read a lot of books, spent a lot of time trying to speed up work processes, and also learned a lot from trying to answer questions on forums like this one, as well as reviewing other people's...
  25. Replies
    12
    Views
    128

    Re: Output error with VBA

    Instead of:


    Cells(ans, 2) = Cells(1, c)

    you could use:


    If Cells(1, c).value = vbnullstring then
    Cells(ans, 2) = Cells(1, c - 1).Value
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4