Find first data row after header when data is filtered.

hi,

I have a macro which works as long as the data is NOT filtered. And i dont understand why it does not work when the data is filtered. I was hoping someone could help me understand and help me figure out a way to get macro to work regardless if data is being filtered.

So here is the problem.
(see enclosed file)

The goal is to determine the first row of data "after the header row which is in row 1 in this case".
Returns 2 if data is NOT filtered
Returns 1 if data is filtered.

Any ideas?

in this file i want the value returned to be 2.......because this is the first data row below the header row which is in row 1.

But when the filter is on it returns the value of 1.

I use this to "check" what the "first data row" value is. The user is supposed to input the first data row but i want to check the file and determine what the first data row is......if the determined value (via vba) does not match the value input by the user then the program stops.

ok, i did not explain this well i guess.

What i am trying to do is determine the FIRST row which contains data AFTER the header row (which is row 1 in this file). In the file example i gave the first row of data After the header row is row 2...........not row 9. Row 9 shows up because the data has been filtered but the first row of data should be 2............

Hi -

Why not just do a loop to test data from row 2 and beyond? Filter will work only for visible cells.

Please Login or Register  to view this content.

Regards,
event

hi event21, i thought the "find" operation that i was doing in the vba was kinda what you suggested but just faster...........

i am showing the find operation that iwas talking about

Please Login or Register  to view this content.

Originally Posted by welchs101

hi event21, i thought the "find" operation that i was doing in the vba was kinda what you suggested but just faster...........

for this purpose, it might not work.

Not all scripts can be used in all instances, thats why majority here is asking for the sample data to easily understand the scenario.

Regards,
event

hi event21,

i did provide sameple data and its on sheet1 of the file i enclosed.

thanks again.

Hi -

Did you try changing the codes from;

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Regards,
event