How to Dim a variable as a Cell?

Question

On Excel, I'm trying to code a macro that involves selecting a range of cells, in which both the upper limit and the lower limit cells in the range are variables. How would I go about programming this?

More specifically:

I have a column A and a column B.  I wish to select a range of cells from column A and merge them together.  That range will be equal to the range of cells in column B that are NOT empty.  So, for example:

If cells B1 to B15 aren't empty (and B16 is empty), then my macro will select the cells A1 to A15 (then merge them).

Anonymous · Accepted Answer

You cannot do it as a Cell. You can do it as a Range.

    Dim c As Range
    Set c = Range("A1")
    c.Value = "AA"

.

garbo7441 · Answer

This is fairly easily accomplished with a macro. However, if your selected cells each contain a value your merged result will contain only the value in the first cell in the selected range.

I am curious what your goal is in achieving that result.

How to Dim a variable as a Cell?

Related Questions

Trending Questions