Determining if next cell is empty

[SER01]

What is the code for determining if the next cell in a given column is empty from within VB?

[jasoncw]

Do you mean the cell below the current (active) cell? If so, this will tell you:

Please Login or Register  to view this content.

HTH

Jason

[SER01]

Do you mean the cell below the current (active) cell? If so, this will tell you:

Please Login or Register  to view this content.

HTH

Jason

What i mean is that if i have a column with values from A1:A30 and A31 is empty then i would like to identify that and perform some calculations at that point. Will the above code do that? Sorry i'm very new to VB.

[jasoncw]

In your example, this will tell you the next empty cell in a column:

Please Login or Register  to view this content.

You can either activate this cell, or determine the address, or various other coding with this information:

Please Login or Register  to view this content.

HTH

Jason

[davesexcel]

this will take you to the next empty cell

Please Login or Register  to view this content.

ot this

Please Login or Register  to view this content.

[SER01]

In your example, this will tell you the next empty cell in a column:

Please Login or Register  to view this content.

You can either activate this cell, or determine the address, or various other coding with this information:

Please Login or Register  to view this content.

HTH

Jason

Determining the Address is most likely what i need. Now my question is in which format will the address be returned. I assume is AX. If so how do i get rid of the letter and only keep the number of the row for further calculations?

[jasoncw]

If the first blank cell is A10, it will return $A$10. If you want just the row number, you can use:

Please Login or Register  to view this content.

Jason

[davesexcel]

Determining the Address is most likely what i need. Now my question is in which format will the address be returned. I assume is AX. If so how do i get rid of the letter and only keep the number of the row for further calculations?

You may need to tell us what are you trying to do in order for us to help..

[Trebor76]

I'll throw my hat into the ring and say that SER01 is trying to sum a dynamic number of entries in Column A starting at cell A1.

If that is the case, he/she can use the following:

Please Login or Register  to view this content.

HTH

Robert