meaning of range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

**MaartenRo** · 06-20-2020, 02:06 AM

Hi,

Does someone know what this line of code exactly means?

 Range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

It selects the filled cells in a row. But i don't understand the sequence of steps.

All input is much appreciated!

**Crooza** · 06-20-2020, 02:22 AM

It selects the active range in column C. It does this by identifying the last row in column C by this piece of code

Cells(Rows.Count, 2).End(xlUp).Row)

**MaartenRo** · 06-20-2020, 02:29 AM

Thank you for the explanation

**Sintek** · 06-20-2020, 05:49 AM

identifying the last row in column B by this piece of code
So C2 to last row represented in Column B

Cells(Rows.Count, 2).End(xlUp).Row)

**Crooza** · 06-20-2020, 08:27 PM

Good pick up.

meaning of range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

meaning of range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

Re: meaning of range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

Re: meaning of range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

Re: meaning of range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

Re: meaning of range("c2:c" & Cells(Rows.Count, 2).End(xlUp).Row).Select

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count number of rows in a range that contain less than 5 cells with the string "VAC"

[SOLVED] VBA "& Cells(Rows.Count)" problem - copying outside of range

range("e1" & cells(rows.Count,5).end(xlup)).Select

Range("B" & Rows.Count).End(3)(2).select

Error rsh = Sheets(st).Range("A" & Rows.Count).End(xlUp).Row + 1

Macro Error with code "Range("A65536").End(xlUp).EntireRow.Insert"

[SOLVED] Cells(Rows.Count, "b").End(xlUp).Row

Bookmarks

Bookmarks

Posting Permissions