Explanation

[ro55co]

hey just wondered if any one could break this line of code down to explain exactly how it works. I know what it does but i dont understand how it does it.

Please Login or Register  to view this content.

[royUK]

Please edit your title to conform with Rule #1. Thanks

[StephenR]

Please Login or Register  to view this content.

finds the last non-empty cell in column A. It is equivalent to going to A65536, the very last cell, and typing Ctrl+up arrow. So the code looks at the range from A1 to the last used cell and counts how many rows are in it.

Since it starts from A1 it is equivalent to:

Please Login or Register  to view this content.

[royUK]

Stephen, please do not respond to questions that a moderator has asked the OP to amend for infringing the Rules, this in fact breaks Rule#7

[StephenR]

roy - if you look you'll see there was a minute between our posts and your's wasn't there when I posted. As it happens when I notice a dodgy thread title or missing code tags I do usually mention it, even though I'm not a mod.

I've seen many occasions on which people have answered a thread contravening the rules but never before a mod making a similar comment.

[royUK]

Your answer wasn't there after I posted, probably it showed up afterwards. I can't speak for other moderators, but I feel that any infringement of the rules needs addressing. We are working hard to make this Forum a useful & enjoyable environment. It's really frustrating to see a question answered that needs amending by the OP like in this case, which means the OP needn't bother with the moderator's comments. Admitted in this case the timing means that it probably was unwitting on your part.

[StephenR]

I'm not arguing that infringements of the rules don't need addressing.

It's really frustrating to see a question answered that needs amending by the OP like in this case, which means the OP needn't bother with the moderator's comments.

I just explained that your comment wasn't there when I posted.

My point was that perhaps you could cut me some slack. I'd like to think that my contribution to this place has been modest but on balance positive. I don't get thanked by moderators for that, but I don't expect to, I'm not complaining, but by the same token I would expect not be treated like an errant schoolboy.

[ro55co]

I know this may seem like im breaking some sort of rule here but how do you change the title of a thread/post. Thanks for the explanation about the code thow.

[mudraker]

ro55co

As it says at the end of Rule 1

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 hours have passed ask a moderator to do it for you

If asking a Mod to do it for you make sue you include what you want the thread title changed to.