Rowcount only based on column A

[JoboM]

Hi there,

I'm trying to rowcount a table, to find the first empty row. However, as some of the columns in the table have If statements, I'd like to rowcount based only on the contents of column A.

That is, if column A is empty in that row, then consider that row empty.

Here is the section of code I am using:

                RowCount = mydata.Worksheets("Logistics Tracker").Range("A4").CurrentRegion.Rows.Count
                With mydata.Worksheets("Logistics Tracker").Range("A4")

Thanks,
Josh.

 

[Rick Rothstein]

Are you trying to get a count of the blank cells in Column A? If so, I think this may work...

[table="width: 500"]
[tr]
	[td]RowCount = mydata.Worksheets("Logistics Tracker").Range("A4").CurrentRegion.Columns(1).SpecialCells(xlblanks).Count[/td]
[/tr]
[/table]

 

[JoboM]

Hmm I tried that line and it didn't work.

I want the code to find the first empty cell in column A (starting at A4), and use that count as the row number to enter the data into.

The code I showed above has been trying to find the first completely empty row in the table.

Thanks for your help!

 

[JoboM]

Rowcount only looking at one column

Hi guys,

I've been attempting a rowcount that only looks at the one column.

I don't care if other columns have data in that row, as long as column A is empty, I would like to know that count (count to the first empty cell in column A)

Thanks!

 

[CyrusTheVirus]

Re: Rowcount only looking at one column

Hi JoboM,

Would the below work? Please use Ctrl+Shift+Enter to enter the formula

=MATCH(TRUE,ISBLANK(A:A),0)

 

[Rick Rothstein]

I want the code to find the first empty cell in column A (starting at A4), and use that count as the row number to enter the data into.

The code I showed above has been trying to find the first completely empty row in the table.

Does this do what you want?

[table="width: 500"]
[tr]
	[td]RowCount = mydata.Worksheets("Logistics Tracker").Range("A4").CurrentRegion.Columns(1).SpecialCells(xlblanks)(1).Row - 3[/td]
[/tr]
[/table]

 

[RoryA]

Re: Rowcount only looking at one column

@JoboM

Please do not repost the same question. I've merged your two threads.

 

[JoboM]

Thanks, Rick!

That worked perfectly. Thanks for your help