Issue with Range involving discontiguous cells in a column

[Grilleman]

So I am trying to figure the best way to select all cells in column B in the workbook I'm opening beginning with cell B2 and down to the last filled cell in column B. The SetRng line of code I have commented out works great for the range B2 to B201. But what if I have cells beyond 201 or... what if only cells B2, B3 and B4 are filled? I had hoped that my second SetRng statement would be a bit more efficient but it produces an 'Object Required' error.

Please Login or Register  to view this content.

[Rick Rothstein]

You cannot Select and assign as value on the same line of code. And there is no need to select anything anyway. Also, all cells must reference the correct worksheet. Change the line of code you marked "THIS DOES NOT WORK" to this and it should be fine...

Please Login or Register  to view this content.

[jindon]

You need to qualify the Parent object for Cells/Range, otherwise it try to read it from ACTIVE sheet.

Please Login or Register  to view this content.