IF activecell is....

[fahimip]

Ive come to the end of writing a code that involves scrolling down to the next empty cell using;
Selection.End(xlDown).Select
What i need is some form of code that will end the sub once the active cell becomes the last cell in the sheet.
Im not sure how to do this using If functions.

Any other ideas will be welcome

any help will be greatly appreciated

 

[Richard Schollar]

Hi

Welcome to the Board!

Using an If statement you could use:

If Activecell.row = Application.Rows.Count then Exit Sub

Best regards

Richard

 

[fahimip]

Richard your a star,

thats exactly what i needed.


Thank for your help