I am working on, let's say sheet2 and have data on sheet8 starting at "G7". I never know how much data will occupy the column, so
I'd like to find the rowcount of the last value before a blank cell in column "G7".

How would the code be written. I have tried many things, all of which are not returning what I am looking for.

Any suggestions?

Hmmm... What exactly are you trying to get as a return value. Are you trying to find what is in G6, or F7, or are you looking for something else?

Mike

Mike
EchoVue.com

The return value I want is, well, Let's say for example data starts at "G7" and ends at "G20" and G21 is blank. I want the return value that counts from G7 to G21 which would be "14".

Actually counting from G7 to G20 which is 14. because it counted up to the last value before the blank cell value which was G21.

In G21 just put the following function...

=COUNTIF(G1:G20,"<>")

Is that what you are looking for? Or are you hoping to do it using VBA?

Mike




Mike
EchoVue.com

Or =COUNTIF(G1:G100, "<>") would give the same answer as well.

Mike
EchoVue.com

Hi,
In VBA, you could do something like:

Range("g7").Select
RowsOfData = ActiveCell.CurrentRegion.Rows.Count

This only works if the colums to the left and right, and the rows above cell G7 are empty - other wise will count extra rows - so may not be exactly what you're after?
Could always write a do loop with activecell.offset, checking for blank cell - but may be a bit like overkill!!