Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.35 seconds.

  1. Re: Counting Odd and Even numbers in a comma-separated list

    I did not, that just made my day!:beerchug:
    (what can I say, I am a math and word geek!)
  2. Replies
    1
    Views
    46

    Re: New column functions carry over

    If you were inserting new rows, I believe that if you use tables, and were inserting new rows within your table, it would do this automatically (because it assumes that each column in the table uses...
  3. Replies
    4
    Views
    43

    Re: Replace or override sub code

    Welcome to the Board!

    Your question seems a bit confusing to me, but I am thinking you can break these different options out into their own Subs, and then based on some decision in your main sub,...
  4. Re: Counting Odd and Even numbers in a comma-separated list

    And yet another possibility, creating your own function in VBA:

    Function CountNums(rng As Range, typ As String) As Long

    Dim arr() As String
    Dim i As Long
    Dim ct As Long

    ...
  5. Replies
    3
    Views
    50

    Re: Deleting only some data in rows

    Because of this:

    and this:

    This should work:

    Sub ClearAmounts()

    Dim lr As Long, r As Long
  6. Replies
    3
    Views
    50

    Re: Deleting only some data in rows

    So, are they always sorted by Bid Number and Award Amount?
    Is Bid Number in column A and Award Amount in column B?
    On each duplicate row, do you just want to clear the Award Amount in column B, but...
  7. Re: Excel 2016 will no record macros to change text color

    Welcome to the Board!

    I have never heard of that happening. Do you have multiple sessions of Excel open at once?
    I am wondering if you are recording macros in one session, but applying the...
  8. Re: budget spreadsheet with min and max and roundup functions

    If you really want it to "round up" as opposed to just "rounding", you will need to amend the solution slightly (see my previous post).
  9. Replies
    5
    Views
    55

    Re: Data fill based on values

    Unfortunately, I do not have the ability to view/download those files from my current location. My workplace security blocks all those sites (many other people are also unable or unwilling to...
  10. Re: budget spreadsheet with min and max and roundup functions

    Alan,
    I think you need to use ROUNDUP, not ROUND, as they said:

    Here is another solution without any IF statements:

    =MIN(MAX(ROUNDUP(A1,-2),10000),35000)

    And Welcome to the Board,...
  11. Replies
    9
    Views
    29

    Re: copy and paste to last row

    You are welcome.
  12. Replies
    5
    Views
    46

    Re: static date on specific cell

    You are welcome.
  13. Replies
    9
    Views
    29

    Re: copy and paste to last row

    I documented my code so hopefully you can see what is happening, can follow along, and make adjustments where necessary.
    It sounds like if you just change all the sheets references of "Sheet2" to...
  14. Replies
    9
    Views
    29

    Re: copy and paste to last row

    Try this:

    Sub FillColA()
    Dim lr As Long
    ' Find last row in column B on sheet2 with data
    lr = Sheets("Sheet2").Cells(Rows.Count, "B").End(xlUp).Row
    ' Copy value from cell A2 to...
  15. Replies
    5
    Views
    46

    Re: static date on specific cell

    Here is some code that will automatically enter today's date in column B when something is entered in column A.

    Private Sub Worksheet_Change(ByVal Target As Range)
    ' If a single cell in column...
  16. Replies
    9
    Views
    29

    Re: copy and paste to last row

    Well, you really did not not answer my question (I asked you for a specific column reference). You provided code, but no data. Without knowing what the original data looks like, all I can really do...
  17. Replies
    1
    Views
    39

    Re: VBA to sort specific range

    I don't think your question is quite clear.
    Can you post a sample of your data, and then post what you would like the expected output to look like?
  18. Replies
    9
    Views
    29

    Re: copy and paste to last row

    How can the last row be determined?
    Obviously, we cannot do it by looking at column A, as that is the column we are populating.
    Is there another column with data we can look at to determine where...
  19. Replies
    5
    Views
    55

    Re: Data fill based on values

    Welcome to the Board!

    You haven't provided a lot of detail, but I think you may be able to do what you want either a VLOOKUP formula.
    See the "How to vlookup from another sheet" section here:...
  20. Replies
    5
    Views
    46

    Re: static date on specific cell

    A cell can either contain a hard-coded value (manually entered in or entered in by VBA), or a formula.
    Any formula that returns the current will always be changing, as it will return the current...
  21. Re: ClearContents of the row if finds all 1's in it.

    Try this:

    Sub ClearRows()

    Dim lr As Long, r As Long
    Dim rng As Range

    Application.ScreenUpdating = False

    ' Find last row in column C with data
  22. Thread: Access Query

    by Joe4
    Replies
    3
    Views
    87

    Re: Access Query

    You are building the query string (strQuery), but I do not see you using it in the open query command.
    I think you actually need to assign that SQL code to your rsQuery object. Otherwise, the query...
  23. Replies
    27
    Views
    259

    Re: Formula Not Returning Expected Value

    You are welcome!
    :)
  24. Replies
    5
    Views
    88

    Re: Same File Name, New Location

    You are welcome!
    Glad I was able to help.
    :)
  25. Replies
    5
    Views
    88

    Re: Same File Name, New Location

    Just change this line:

    buPath = "C:\Temp\"
    to

    buPath = ActiveWorkbook.Path & "\backup\"
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4