Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Macro Excel put values down columns

    Assuming that your first column always has values, you should be able to use this

    Worksheets("AC").Range("O2:O" & cells(rows.count,1).end(xlup).row).Value = range("O" &...
  2. Re: evernote/html conversion to excel

    Have you tried using text to columns fixed width option to split the results?

    Or use Data->From Web option and direct the browser to your local HTML file using file:///C:/fullpathtoyourfile.html
  3. Re: Pivot Table Data Source Issue

    When you right click on Pivot Table-> Pivot Table Options->Data->Save Source Data With File.

    Uncheck and try again. Let me know.
  4. Re: Pivot Table Data Source Issue

    I can't replicate your problem. Anybody else who can replicate this problem?
  5. Re: Pivot Table Data Source Issue

    edit: sorry, misread
  6. Re: Pivot Table Data Source Issue

    In your original file, under Analyze->Change Data Source, what's the data source?
  7. Re: Determine a value from Conditional Formatting

    How come Friday is not highlighted?
    Also I don't know what you mean by 2 or 3 days greater? So which one is it?

    Here is an example of greater than 2 days. This will return 4.

    <table...
  8. Re: Pivot Table Data Source Issue

    Which version of excel is this?

    When you right click on Pivot Table-> Pivot Table Options->Data->Save Source Data With File is it checked?
  9. Replies
    7
    Views
    185

    Re: Variable value lost

    You can do this



    Public x As Integer


    Sub Macro1()
    x = 1
    End Sub
  10. Re: Numeric value only in a cell (no dates)

    Try this:

    =AND(ISNUMBER(A1),LEFT(CELL("format",A1))<>"D",MOD(A1,1)=0,LEN(A1)<7)
  11. Re: Is there a VBA command that will turn a string of letters and numbers into just a number?

    What I was trying to say it won't extract the number out of it. So A123 will return 0, not 123.
  12. Re: Numeric value only in a cell (no dates)

    Yes, it's an invalid date, so it will be treated as text.

    You want to use AND() function to handle the rest, something like AND(ISNUMBER(A1),LEFT(CELL("format",A1))<>"D",OTHER_CONDITIONS)
    In...
  13. Re: Numeric value only in a cell (no dates)

    You can use LEFT(CELL("format",A1))<>"D" to make sure it's not a date.
  14. Replies
    17
    Views
    377

    Re: "Next Without For" Error

    You only need the last "Next x", remove all the others.

    You will most likely also need to wrap your if statement string conditions in quotes, like If Division = "York" Then
  15. Re: Is there a VBA command that will turn a string of letters and numbers into just a number?

    Keep in mind that Val will only work if your string always starts with a number and then text follows it.
  16. Re: Is there a VBA command that will turn a string of letters and numbers into just a number?

    You could do this. Keep in mind that all the other characters will be removed as well, so if your text is "A4556.56BH", this will result in 455656



    Function StripChar(aText As String)
    Dim...
  17. Re: Conditional Formatting for a date

    OK, I've missed that part in your explanation. Try this:


    =AND(WEEKNUM(E6,2)=WEEKNUM(TODAY(),2),WEEKDAY(E6,2)<6,YEAR(E6)=YEAR(TODAY()),E6>=TODAY())
  18. Re: Date stamp when cell contents have been edited. Excel

    Yes, but you will have to use VBA.

    See an example here
    https://www.mrexcel.com/forum/excel-questions/662266-excel-visual-basic-applications-add-comment-change-cell-value.html
  19. Re: Conditional Formatting for a date

    This should work.


    =AND(WEEKNUM(E6,2)=WEEKNUM(TODAY(),2),WEEKDAY(E6,2)<6,YEAR(E6)=YEAR(TODAY()))
  20. Re: Excel Macro refuses to copy formula

    What's in your B column on that tab?
  21. Replies
    6
    Views
    203

    Re: Run code until

    Try this



    Sub DoStuff()


    Dim Server As String
    If Range("CS73").Value = "FALSE" Then
    Server = "P2"
  22. Re: Excel 2016-Use MS Query Question

    It's not 100% clear to me what the issue is.
    From what I can tell your field names in your table change.
    You don't need to refer to particular fields in your ODBC connection to pull the data to...
  23. Re: Count Cells that have a formula, only if the cell returns a value

    Use COUNT
  24. Re: Is it possible to colour a partial text in VBA???

    theCell.Characters(11, 5).Font.ColorIndex = 3
  25. Re: Coping Notes from one excel sheet to another using a common column

    VLOOKUP function is what you're looking for. The last video is what you're looking for, but make sure you lock the entire table range, not just the columns in the table range....
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4