Hi...
In this soccer betting spreadsheet, and from the start I've hidden all future coupons, exept this weeks, and next.
And when I type in the first match in this week's coupon, the coupon for the week after that will unhide.
I have triied with this solution:
If Range("e8") = "" Then
Rows("46:3434").EntireRow.Hidden = True
Else
Rows("24:3434").EntireRow.Hidden = False
Rows("46:3434").EntireRow.Hidden = True
End If
If Range("e30") = "" Then
Rows("68:3434").EntireRow.Hidden = True
Else
Rows("46:3434").EntireRow.Hidden = False
Rows("68:3434").EntireRow.Hidden = True
End If
If Range("e52") = "" Then
Rows("90:3434").EntireRow.Hidden = True
Else
Rows("68:3434").EntireRow.Hidden = False
Rows("90:3434").EntireRow.Hidden = True
End If
But after a few weeks it starts getting really slow.
Se attached workbook.
Is there another way to do this, so I can avoid this terrible loss of speed?
I am not an expert in VBA, but I get along. I guess :-D
Thanks in advance.
Best wishes
Tresfjording
Bookmarks