Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.14 seconds.

  1. Replies
    2
    Views
    75

    Re: Populate then clear

    Welcome to the Board!

    Unfortunately, your code has all run together, rendering it virtually unreadable.
    Try posting it again, using Code Tags, as described here:...
  2. Replies
    9
    Views
    168

    Re: AutoFill Across Columns

    You are welcome!
    I am glad to see that you are taking an interest in not just getting answers, but learning and understanding it. I love when people do that!

    As you might have already guessed,...
  3. Re: Need to add todays date everytime i save file

    In your original posting, you cut off your code aftet that comma. That indicates that line of code is continued. But since you cut it off, I do not know what it was, which is what I had placed the...
  4. Re: Need to add todays date everytime i save file

    Try:

    Dim fname as String
    fname="C:\Users\frank\Desktop\OCIP\LCP - " & Format(Date,"mm-dd-yyyy") & ".xlsx"
    ChDir "C:\Users\frank\Desktop\OCIP"
    Application.DisplayAlerts=False...
  5. Replies
    9
    Views
    128

    Re: VBA explanation please.

    You are welcome.
    Glad I was able to help!
    :)
  6. Replies
    9
    Views
    168

    Re: AutoFill Across Columns

    I think this will clarify things for you a bit:

    Go into any cell on your Excel worksheet, and enter the formula:
    =Column()
    and see what it returns.

    What it is returning is the column number...
  7. Replies
    1
    Views
    23

    Re: Conditional formatting

    Welcome to the Board!

    Select the whole row, go to Conditional Formatting, select the Formula option (last one), and enter this formula:

    =today()>=date(2019,8,23)
    (changing the date to whatever...
  8. Replies
    9
    Views
    168

    Re: AutoFill Across Columns

    You are welcome.

    Quite frankly, auto-fill is often unnecessary in VBA. If you are just copying the same formula or value across a whole range of cells, you can just apply that formula/value to...
  9. Replies
    9
    Views
    128

    Re: VBA explanation please.

    OK, in re-reading it, I think I originally misinterpretted your follow-up request. It sounds like you are only concerned about changes to C54 on Sheet1 (not every sheet), but want it to affect every...
  10. Re: VBA Insert Formula and copy to last row in column/Table

    You are welcome.
  11. Replies
    9
    Views
    128

    Re: VBA explanation please.

    You are welcome.
  12. Replies
    9
    Views
    168

    Re: AutoFill Across Columns

    Try this:

    Application.ScreenUpdating = False

    With Sheet1
    lc = .Cells(1, .Columns.Count).End(xlToLeft).Column
    .Rows("1:1").Insert
    .Range(Cells(1, 1), Cells(1,...
  13. Replies
    9
    Views
    128

    Re: VBA explanation please.

    The Worksheet_Change code is specific to the sheet module that the code is located in. So it would need to be placed in each sheet module.
    Though, I think there might be a way to do it across all...
  14. Replies
    12
    Views
    181

    Re: Counting a Time Range with COUNTIFS or SUMIFS

    You can quickly verify with the ISNUMBER function (as dates/times are stored in Excel as numbers).

    So, if your time entry is in the cell A1, then enter this formula anywhere:
    =ISNUMBER(A1)
    If it...
  15. Re: VBA Insert Formula and copy to last row in column/Table

    Quotes and double-quotes are always problematic because text qualifiers need to be differentiated from literal quotes/double-quotes. It can make your head spin!

    Here is an easy way to get the...
  16. Replies
    9
    Views
    128

    Re: VBA explanation please.

    If cell C54 is manually updated, the code will run and compare each of the values in the range D7:S7 to the new value in cell C54.
    For each of those cells, if their value is greater than the value...
  17. Re: Is it Possible to write a Match Formula with a Defined Name Range?

    If you want a count, try:

    =COUNTIF(Yellow,"Satisfactory")
  18. Re: Is it Possible to write a Match Formula with a Defined Name Range?

    Yes, the "#N/A" error usually means it is not finding any matches.
    Note that it needs to match exactly. Something as simple as an extra space on the end of "Satisfactory " will cause it NOT to...
  19. Thread: date +5

    by Joe4
    Replies
    7
    Views
    77

    Re: date +5

    No such thing exists. It actually isn't possible, if you really think about it.
    Remember, not only does every country have their own holidays, different companies/entities have different holidays...
  20. Thread: Formula check

    by Joe4
    Replies
    10
    Views
    190

    Re: Formula check

    I do not know what you mean. Please explain in more detail.
  21. Thread: Saving a "Sort"

    by Joe4
    Replies
    1
    Views
    22

    Re: Saving a "Sort"

    Turn on your Macro Recorder, and record yourself sorting the report. Then stop the Macro Recorder.
    You will have just created/saved VBA code that will do that sort. So you can just run the code.
    ...
  22. Thread: date +5

    by Joe4
    Replies
    7
    Views
    77

    Re: date +5

    Did you look at the example in that link? It shows you exactly how to do it with a simply example. Just copy the exact same process.

    Your formula would look something like:
    ...
  23. Thread: date +5

    by Joe4
    Replies
    7
    Views
    77

    Re: date +5

    Use the WORKDAY function.
    See: https://exceljet.net/excel-functions/excel-workday-function
  24. Replies
    4
    Views
    53

    Re: VBA PasteAll Question

    Merged cells cause all sorts of problems for VBA and other Excel tasks (like sorting). I strongly encourage you to get rid of them.
    If you are simply merging across rows, you can achieve the same...
  25. Replies
    1
    Views
    180

    Re: mail merge change the format of the date

    Excel is just sending the data over to Word, not the formatting.
    You need to format it on the Word side.
    See:...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4