AutoScroll/Smallscroll problem VBA

[JWebb]

Working on PC using excel 2016.

I have a userform macro that once filled out takes to user to the applicable worksheet and selects the applicable row. What I can't seem to get fixed is autoscrolling that work sheet to the active row. The active row location is always unknown (could be the first row or the last).

My code is:

ActiveSheet.Range("C:C").Find(Sheets("shhet2").Range("D1"), Lookin:=xlValues, LookAt:=xlWhole, Ma
tchCase:=True).EntireRow.Select
'the above works just fine
"the below doesn't
Activewindow.Scrollrow = ComboBox3.value

I get a 'type mismatch' error.

When I hover in the debugger, ComboxBox3 value is correct but when I hover over the scrollrow it is incorrect even the the correct row is selected (highlighted as active).

Thanks in advance!

 

[JWebb]

So I tried another angle:

Activewindow.SmallScroll Down:=ActiveSheet.Range("C" & Activecell.Row).Value, Up:ActiveSheet.Range("C" & Activecell.Row).Value

I did down and up just in case it would ever need to scroll up based on the users next selection.
I get a "smallScroll method of Window class failed" error.

My whole goal here is to make the activerow visible to the user so they don't have to scroll to find it as there could be 400ish rows on a given sheet. Doesn't matter to me how I get there.

Any help is much appreciated.

 

[JWebb]

Nevermind, I'm an idiot

ActiveWindow.ScrollRow = Selection.Row

puts it right at the top everytime - just like the code tells it to.
I knew it was simpler than I was making it.

Thanks to all who have read this post.