• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. U

    REPT()'s Order of Evaluation

    It's not a matter of great import. I simply prefer to use REPT in place of IF when I don't want to return anything if FALSE. IF requires me to return at least an empty string (""). REPT, returns absolutely nothing if number_times = 0. However, I'm not going to waste calculation on REPT, when...
  2. U

    REPT()'s Order of Evaluation

    Sorry, I meant =REPT(A1 A2, 0) The point being, an invalid reference. I could have used 1/0, #N/A, or anything else that results in an error as well, the result is the same, the error shows up, even if number_times = 0.
  3. U

    REPT()'s Order of Evaluation

    In addition to Evaluate Formula resolving REPT from left to right, I see that the text argument will return an error, even if number_times = 0. For example, =REPT(A1 A1, 0) returns #NULL!. My only doubt is, that REPT probably wasn't built to be an IF, the way we're using it, so, it may be...
  4. U

    REPT()'s Order of Evaluation

    I often use REPT in place of an IF where I need the text value only if TRUE. Question: Does REPT evaluate the text argument only if the number_times is TRUE, or does it evaluate the arguments in order? Why does this matter? Let's say I have a formula that looks like this...
  5. U

    Can hidden destination rows be included when pasting?

    Thank you! That is exactly what I was after. An Alt+HVV gets the job done in a blink of an eye, no macro needed. For some reason, GetText was tacking on a CRLF, so I was slicing it off.
  6. U

    Can hidden destination rows be included when pasting?

    p45cal Thank you for your solution. Since there doesn't appear to be any non-VBA solution available, at least I can avail myself of your far more efficient code than what I'd originally suggested. SirJB7 Thank you for your efforts. Please see p45cal's answer. It seems to me that your code...
  7. U

    Can hidden destination rows be included when pasting?

    Thank you. I just tried plugging in your code. It doesn't paste into the filtered rows, it only pastes to the visible cells. I'd be very interested in obviating the loop, but it still seems to be the only proven way for me to get the values into the hidden cells.
  8. U

    Hello .. Introduce yourself

    Hi, I'm UniMord from Far Rockaway, New York. I'm a Data Analyst, and I spend far more of my day with Excel than I do with all my family and friends put together. I'm not sure this is such a good thing, but, I do love Excel. I was attracted to Chandoo's website because there's a pervasive spirit...
  9. U

    Can hidden destination rows be included when pasting?

    Thank you SirJB7. What you've advised, unfortunately for me, is the precise opposite of what I'm seeking to accomplish. In the scenario presented in the original question, we're faced with a filtered table, where I want to paste in a value, while including the hidden cells as well. Imagine a...
  10. U

    Can hidden destination rows be included when pasting?

    Hi All! I'd like to copy a value into a filtered range and include the hidden cells. When pasting a series of cells, this is the default, usually undesired, behavior, i.e., your values disappear into a filter sinkhole. But, when the value originates from a single cell, is a <Ctrl><Enter>, or...
Back
Top