Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Formula bar value vs displayed cell value

    Well, truly, it doesn't matter where it happens, I guess, but I don't know how to put an 'If' statement into VBA.
    The whole story is that I need a macro for a dynamic range that will convert that...
  2. Re: Formula bar value vs displayed cell value

    Could you maybe come up with a more complex answer, please?
    Once again, I'm going to feel really dumb because I spent so much time trying to do what turns out to be a very simple thing.

    Thank...
  3. Formula bar value vs displayed cell value

    Good rainy afternoon. Perfect time for doing computer stuff. :)
    I export, in to excel, reports from a database.
    In one of my columns, (start time), the cell value displays as 0001
    However, what...
  4. Re: Longest Column not finding last couple of rows

    Thank you to all of you for taking the time to help address my issue.
    Mark858s code that includes would have a "" formula result, seems to have fixed the problem.
    It amazes me how much I have...
  5. Longest Column not finding last couple of rows

    Good morning/afternoon.
    If someone has some time to help, I would appreciate it. :)

    So, I've been using this code to find my longest row/column range so I can put 'all borders' around each cell...
  6. Re: Dynamic range, conditional formatting, where second character in field is "e"

    <---idiot
  7. Re: Dynamic range, conditional formatting, where second character in field is "e"

    Thank your for answering. I know you probably have many other things you could be doing.
    I'm sorry, but I don't know how to do anything with what you've given me but, again, thank you.

    -Christine
  8. Dynamic range, conditional formatting, where second character in field is "e"

    As always, any and all help and suggestions are welcome. :)

    I'm very happy that this weekend is almost over, because my brain is full of Excel and it's made me start drinking wine already.

    So,...
  9. Replies
    4
    Views
    123

    Re: Multi level sort on a dynamic range

    Thank you to both of you for responding. :)
    Leith, yours worked but I wasn't able to respond to let you know, until now.
    DanteAmor, thank you, also, for responding. I haven't yet tried your code,...
  10. Replies
    4
    Views
    123

    Multi level sort on a dynamic range

    Good afternoon...again. :)

    I'm surprised I can't find some already built code on how to do a multi level sort on a dynamic data range...but I've not found any so far, so I have to bother everyone...
  11. Re: If cell value = something, then cut row and paste to next sheet

    Fluff, yours works just fine.
    Irobbo, I'm not sure if yours will work, because I'm not sure what I need to change to make it look at column 1 instead of column 2.

    Thank you! I'm very sorry about...
  12. Re: If cell value = something, then cut row and paste to next sheet

    Ummm....whooops. I see that I was asking about column B in my original post.
    *face palm*
  13. Re: If cell value = something, then cut row and paste to next sheet

    Column A.
  14. Re: If cell value = something, then cut row and paste to next sheet

    I have headers in row 1 of Sheet1 and of Sheet2. If it matters, my headers are: ID, Name, Number, start time, end time, location, reason, mandatory.
    I am using Office 365.
    Column A will always...
  15. Re: If cell value = something, then cut row and paste to next sheet

    I have a header in row one on Sheet1 and on Sheet2. Both sheets are in the same workbook. If it matters, my headers are: ID, Name, Number, Start time, End Time, Location, Reason, Mandatory....
  16. Re: If cell value = something, then cut row and paste to next sheet

    Hmmm...if these work for both of you, then I'm going to assume that I'm the one doing something wrong. I'm using Office 365.
    Fluff, I don't get any errors with your code, but it doesn't seem to do...
  17. Re: If cell value = something, then cut row and paste to next sheet

    Again, thank you for taking the time to help me.

    I'm getting a run-time error again, but it's now happening at this line:

    ws2.Range("A" & Rows.Count).End(xlUp).Offset(1).Resize(UBound(AL) +...
  18. Re: If cell value = something, then cut row and paste to next sheet

    Thank you for taking the time to help. I really appreciate it.
    When I run the code, I get a run-time error. Automation error and the debug shows this line in yellow: Dim AL As Object: Set AL =...
  19. If cell value = something, then cut row and paste to next sheet

    Good afternoon and thank you for any help or advise.

    I am trying to look through a dynamic range in column B and, where the column B value has a 2nd character = "E", then cut that entire row and...
  20. Re: Insert the header row proceeded by 4 blank rows at each change in a column value

    Fluff, I can't thank you enough!
    It works perfectly.
    A huge thanks to you and everyone else who stops in here to help! :)
  21. Insert the header row proceeded by 4 blank rows at each change in a column value

    Good morning :)
    I've been looking all over for a macro that does what I need, but I have been unable to find one, so I will appreciate ANY help someone can offer.

    I have a report that has about...
  22. Re: Insert blank rows when field value changes

    Thank you so much, Peter.
    I KNOW that had probably already been asked, but I couldn't find the thread anywhere.

    I appreciate the time you take to stop in here and help us. :)
    -Christine
  23. Insert blank rows when field value changes

    Thank you to anyone who can help me.

    I need to insert 4 blank rows every time there is a value change in column B.
    AND, if you're feeling happy, I'd actually like to insert 5 rows...4 blank ones...
  24. Re: macro to sort by multiple columns with no header, on a dynamic range selected using an input box and no header

    It works much better when *I* do what I'm supposed to. :)
    What you guys do by taking time to help on here makes SO much difference for those of us who don't know how to do it.
    Thank you for taking...
  25. Re: macro to sort by multiple columns with no header, on a dynamic range selected using an input box and no header

    I appreciate you taking the time to help me, MickG.
    When I tried to run it, it said it needed an 'end sub', so I stuck one in down below the "Next Dn".
    But when I run it on some data, nothing gets...
Results 1 to 25 of 26
Page 1 of 2 1 2