Code stops at blank cell

[nice]

Hi I am try to run some code and it keeps stoppng at an empty cell I have checked the cell is empty it is I have tried some of the solution on other post and I'm obviously doing something wrong but I don't know what it is basically reading football reults and taking the home goals as one figure in next column but where a game was postponed i have a blank cell and code stops any help with be very much appreciated

For i = 2 To finalrow
    
    lg = Left(ActiveCell.Offset(0, -1), 2)
    Cells(i, 8) = lg
    Range("h30").End(xlUp).Offset(1, 0).Select
    

  If i = 30 Then Exit For

Next i

 

[Joe4]

Welcome to the Board!

I think your issue could be with how your "finalrow" value is being calculated, but you have not posted that part of your code.
Could you post that?

 

[nice]

My final is calculated from another sheet with 381 lines

 

[nice]

My final is calculated from another sheet with 381 lines

 

[Joe4]

It is very difficult to debug without seeing which columns your data resides in on your sheet (you included the header row, but not the part of the screen print which shows us exactly where you data is located (and your code refers to column "H").

Which of those data columns is column H?

 

[nice]

can i send the whole workbook is that possible

 

[Joe4]

You cannot attach files to your posts on this site.

However, MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

If you could just include your row and column headers, so I can see exactly where everything is on your worksheet, then it would make more sense what your code is doing.

 

[nice]

My sheet takes results from an external source adds them to a sheet then my code goes through all the data and places all the data onto named sheets of the teams breaks down all the scores and adds them to a league table I dont know how would post all that for you to see in bits

 

[Joe4]

Up in your very first post, you posted a screen print.
Just post one that includes the Column Letters and Row Numbers for me to see!

It is hard to know what your code is doing in relation to your data when I cannot tell which columns/rows of data it is referencing!
All I need is a picture of your data (like in one run), that shows these column letters and data row numbers along with your data.