Setting visible cell range apart from header

[immigrated4urjob]

Please Login or Register  to view this content.

At the moment the first line of code selects the header as well.

Any idea how to exclude the header?

[WideBoyDixon]

Which row is the header on?

WBD

[immigrated4urjob]

Which row is the header on?

WBD

G1. Or, first row. Tried changing first argument from g1: to g2 but to no avail.

G = 7 col index

[WideBoyDixon]

Two things:

1. Aren't you missing a ".Row" after .End(xlUp) ?
2. You're setting the entire Range value to be "Released" if any cell is not already "Released" - why not just do Rng.Value = "Released" - no point doing the test?

Please Login or Register  to view this content.

WBD

[TMS]

Think this:

Please Login or Register  to view this content.

should be this:

Please Login or Register  to view this content.

[immigrated4urjob]

Two things:

1. Aren't you missing a ".Row" after .End(xlUp) ?
2. You're setting the entire Range value to be "Released" if any cell is not already "Released" - why not just do Rng.Value = "Released" - no point doing the test?

Please Login or Register  to view this content.

WBD

Thanks it worked. Should have done it the easier way.

Also, row 1 changes to released even though I specified row 2 to be starting range.

So for that I added if condition to change to value back to original column if it turns out to be the case.

[immigrated4urjob]

Think this:

Please Login or Register  to view this content.

should be this:

Please Login or Register  to view this content.

What is the difference between .Cells(.Rows.Count,7) and Cells(Rows.Count,7)?

[TMS]

Ignore me. Total confusion.