In my macro, the code is as follows:
For some reason the page doesn't pick up rows 202 on. When I originally wrote this code, it only went up to line 202, but I have since added 2 more rows, so I changed the range to include them (to L205). How come it isn't picking them up when it creates the webpage? It still stops at 202. Any ideas?
Code:
Range("C24:L205").Select
Range("L205").Activate
With ActiveWorkbook.PublishObjects("Gamepreviews_18753")
.HtmlType = xlHtmlStatic
.Filename = "C:\Gamepreviews.htm"
.Publish (False)
.AutoRepublish = False
End With
ChDir "C:\"
Windows("Rosters.xls").Activate
ActiveWindow.Close
Range("C5").Select
End Sub
For some reason the page doesn't pick up rows 202 on. When I originally wrote this code, it only went up to line 202, but I have since added 2 more rows, so I changed the range to include them (to L205). How come it isn't picking them up when it creates the webpage? It still stops at 202. Any ideas?