Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.77 seconds.

  1. Re: Prompt user if file save is cancelled

    This should work


    strFilePath = vbNullString

    Do While strFilePath = vbNullString
    strFilePath = Application.GetSaveAsFilename(InitialFileName:=File121, FileFilter:="PDF Files (*.pdf),...
  2. Re: Formula? Extract text between 2 characters

    Would =MID(A1, LEN(A1)-10, 10) do what you want?
  3. Re: Help with formula to include all data rows - =SUMPRODUCT maybe?

    First, the numbers in the first spreadsheet don't match the words. (Return of 62.50??)

    SUMFIS should do what you wwant


    =SUMIFS(BETS!$E:$E, BETS!$A:$A,"Bet123", BETS!$E:$E,"<>") would give you...
  4. Re: macro change back to "thisworkbook" from "active workbook"

    You don't need to select worksheets to copy their contents.

    But, if you qualify the sheet that you are activating, that should work.

    For i = 1 To reqdb.Sheets.Count
    ...
  5. Replies
    3
    Views
    90

    Re: Sum of Multiply Cells

    What happened when you tried it?
  6. Re: Go to cell by matching value in a column

    It would help to see your code to figure out what would work for you.
  7. Replies
    3
    Views
    90

    Re: Sum of Multiply Cells

    Try =SUMPRODUCT(A2:A9,B2:B9)
  8. Re: Go to cell by matching value in a column

    What code do you have?
    Did it work at one time? What happened to change that? Did you get a new version of Excel or ....?
    What are the details of "doesn't work"? Does it do nothing or go to the...
  9. Re: Resume macro to next line when get Prompt

    If your VBA routine doesn't need the remote action to be completed in order for the VBA's task to be completed, why not initiate the remote action after the VBA has completed its task?
  10. Replies
    2
    Views
    60

    Re: How to display these combinations

    Wouldn't the formula =TEXT(ROW(A1),"0000") dragged down do what you want?
  11. Re: Data validation to disallow blank entry when using drop down list

    When setting the Data Validation, un check the Ignore Blanks box.
  12. Re: Can Data Validation be imported and used in a separate sheet?

    If you want a change on the Main sheet also reflected on the Rep sheet, and vice versa, you are trying to set up a circular reference, which can not be done with formulas.

    That code gets put in...
  13. Re: Helping a New VBA User With Efficiency in VBA

    The formula approach that you use is a pretty efficient way to do things.

    Calculating formulas in cells is a ton faster than making the same calculation in VBA.
  14. Re: Can Data Validation be imported and used in a separate sheet?

    It sounds like you have a main sheet and a rep sheet that is essentially a filtering of the main sheet.

    You want the Result column cells on the rep sheet to be linked to the Result column sheet on...
  15. Re: Create a List using IF(AND from other tabs

    Advanced Filter with the Copy To Other Location option can create the tables, but updating them dynamically would be a problem.
  16. Re: How can i replace this "a" without application ran code?

    Which was faster when you tried them on your spreadsheet?
  17. Re: changing a 2 decimal place number into a whole number in a macro

    If DestinationRange is the range of cells with those data, perhaps


    With DestinationRange
    .Parent.Parent.PrecisionAsDisplayed = True
    .NumberFormat = "0%"
    ...
  18. Re: How can i replace this "a" without application ran code?

    You could do this without VBA

    =IF(A1="no", "", SUM(OFFSET(A1,0,0,MATCH(A1,A2:A$65536,0),2)))
  19. Re: Need a way of creating a reference number

    If you have a name, first, last, whatever, as long as it is unique to the customer, you can remove odd characters and replace spaces with underscores.

    you could do something like


    idString =...
  20. Re: How to link specific worksheet to my combobox?

    It sounds like these are ActiveX controls. My Mac doesn't support ActiveX, but from reading threads in the forum, I think that this will populate the List box with those two sheets.


    Private Sub...
  21. Re: want to see if a range doesn't contains any values other than this

    Try
    =IF(COUNTIF(A1:A10,"October")=COUNTA(A1:A10), "No", "Yes)

    or if you want a blank cell to trigger the Yes response, hard code in the 10.
  22. Re: How to link specific worksheet to my combobox?

    The part in brackets isn't code, its pseudo code indicating what the code is supposed to be doing at that point.
    How is the code to distinguish which sheets are archive and which are current?
    Do...
  23. Re: How to link specific worksheet to my combobox?

    I don't know how you the program is to differentiate between Archive and Current worksheets, but the place to put that test in is


    For Each xSheet In ThisWorkbook.Sheets
    If [xSheet is a...
  24. Re: Carriage Return or Line Break or ALT+Enter in Cell problem

    Is the cell's alignment Wrap Text set to On or Off?
  25. Re: Need a way of creating a reference number

    Wouldn't it be wise to create a reference number by cocatenating the customer name and the date/time (e.g. SMITH_20190831_1423)that the quote is made. That would provide a unique reference number,...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4