Excel can't find last row of data

[awbf]

Good afternoon, I am having an issue where excel is not going to the last row of data. The code line I am using is the following.

Please Login or Register  to view this content.

What happens is when it looks for the last row of data it goes 3 or 4 rows past the last row of actual data. Any thoughts on how to get past the "dirty" cells? Thanks in advance.

AWBF

[VBA Noob]

Maybe reset the used range

http://www.contextures.com/xlfaqApp.html#Unused

VBA Noob

[awbf]

Thanks VBA Noob
I added the module to my macro but it still does not clear the problem. I still get 3 lines below the data. Any other thoughts??

[VBA Noob]

Not without taking a look at the workbook. Post the sheet removing any confidential info

VBA Noob

[VBA Noob]

Or see if this helps to determine the last cell instead of LastCell

Please Login or Register  to view this content.

VBA Noob

[awbf]

Thanks VBA Noob
I tried the code and it finds the rows perfect. Now when I apply it to my formula I get an error. Error is:
LastCell.Row=<Object Required>

Please Login or Register  to view this content.

This is where I am a noob, not sure what I should be adding to the code???