none
VBA EXCEL RRS feed

  • Question

  • I am having trouble trying to think of a way to get what I need done.

    I have an excel document that I put in a value in between B3-B52.

    I want to copy cells K3-K52, if there is a value in B3-B52.

    Example:

    B3:TODAY

    B4:TOMORROW

    B5:YESTERDAY

    B6:"BLANK" AND SO ON.

    Then I would want it to copy K3-k5 because those are the only cells that had data in them.

    I know how to select the only cells that have a value with

    ActiveSheet.Range("b3", ActiveSheet.Range("b3").End(xlDown)).Select

    but this doesn't help me understand how to get it to copy the ones from K column.

    • Moved by Bill_Stewart Wednesday, December 3, 2014 10:51 PM Move to more appropriate forum
    Wednesday, December 3, 2014 8:01 PM

Answers

All replies