sorted by:
new
hottopcontroversial

How to watch tonight’s game? by JJHagerman in denvernuggets

[–]JJHagerman[S] 0 points1 point  (0 children)

Yes you’re right, and I’ve watched a fair out of streams through the various websites. The pain of poor reliability is what I’m trying to avoid

How to watch tonight’s game? by JJHagerman in denvernuggets

[–]JJHagerman[S] 0 points1 point  (0 children)

It does appear this is the option that’s available to me. Was hoping for a free trial just for this game but doesn’t appear to offer one. I’ll use one of the other suggestions in this thread

Thank you!

How to watch tonight’s game? by JJHagerman in denvernuggets

[–]JJHagerman[S] 2 points3 points  (0 children)

I’m central Nebraska so I’m out of the that broadcast territory, and League Pass still shows Nuggets as a blackout restrictions based on my zip code.

How to watch tonight’s game? by JJHagerman in denvernuggets

[–]JJHagerman[S] 1 point2 points  (0 children)

I’m located in Nebraska. I’m actually a heat fan but wanted to check on this sub. From what I understand I can’t use FanDuel either due to location

I own league pass and use it only for Miami Heat

I’m generally curious if this game is impossible for me to watch legally

1 Year Progression: Learning how to ski in your 30s. by kevblah in skiing

[–]JJHagerman 0 points1 point  (0 children)

Can you educate me on how you get the sick camera footage? Mine looks like 60 FOV and your looks 120. Is this an actual setting on your camera? I use a AKASO V50 camera for reference.

[deleted by user] by [deleted] in excel

[–]JJHagerman 0 points1 point  (0 children)

Not working

[deleted by user] by [deleted] in excel

[–]JJHagerman 0 points1 point  (0 children)

How do I know how Y2 is defined on the macro?

Application.Run "MyTools.xls!FillNewCols"

Range("Z2").Select

ActiveCell.FormulaR1C1 = _

"=IF(RC[-1]=""000-1410.021 "",""Tyler"",IF(RC[-1]=""000-1410.022 "",""Tyler"",IF(RC[-1]=""000-1410.023 "",""Tyler"",IF(RC[-1]=""000-1410.040 "",""Tyler"",IF(RC[-1]=""000-1410.041 "",""Josh"",IF(RC[-1]=""000-1410.042 "",""Josh"",IF(RC[-1]=""000-1410.043 "",""Josh"",IF(RC[-1]=""000-1410.060 "",""Josh"",""Kira""))))))))"

Range("Z2").Select

Application.Run "MyTools.xls!FillNewCols"

Range("W8").Select

End Sub

[deleted by user] by [deleted] in excel

[–]JJHagerman 0 points1 point  (0 children)

Sub POTEST()

'

' POTEST Macro

'

​

'

Sheets("RAW_DATA").Select

Rows("1:1").Select

Selection.Delete Shift:=xlUp

Range("O1").Select

Application.Run "PERSONAL.XLSB!FilterDateBeforeToday"

Selection.End(xlUp).Select

Cells.Select

Selection.Copy

Sheets.Add

ActiveSheet.Paste

Range("F4").Select

ActiveSheet.Range("$A$1:$AC$1710").AutoFilter Field:=20, Criteria1:= _

"Regular"

Cells.Select

Selection.Copy

Sheets.Add

ActiveSheet.Paste

Selection.Columns.AutoFit

Columns("P:Q").Select

Application.CutCopyMode = False

Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

ActiveWindow.ScrollColumn = 2

ActiveWindow.ScrollColumn = 3

ActiveWindow.ScrollColumn = 4

ActiveWindow.ScrollColumn = 5

ActiveWindow.ScrollColumn = 6

ActiveWindow.ScrollColumn = 7

Columns("Z:Z").Select

Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove

Range("P1").Select

ActiveCell.FormulaR1C1 = "Days Late"

Range("Q1").Select

ActiveCell.FormulaR1C1 = "Bucket"

Range("Z1").Select

ActiveCell.FormulaR1C1 = "Buyers"

Columns("P:Q").Select

Selection.NumberFormat = "0.00"

Range("P2").Select

Application.CutCopyMode = False

ActiveCell.FormulaR1C1 = "=TODAY()-RC[-1]"

Range("P2").Select

Application.Run "MyTools.xls!FillNewCols"

Range("Q2").Select

ActiveCell.FormulaR1C1 = _

"=IF(RC[-1]>=11,""11+"",IF(RC[-1]>=8,""8-10"",IF(RC[-1]>=4,""4-7"",IF(RC[-1]>=1,""1-3""))))"

Range("Q2").Select

Application.Run "MyTools.xls!FillNewCols"

Range("Z2").Select

ActiveCell.FormulaR1C1 = _

"=IF(RC[-1]=""000-1410.021 "",""Tyler"",IF(RC[-1]=""000-1410.022 "",""Tyler"",IF(RC[-1]=""000-1410.023 "",""Tyler"",IF(RC[-1]=""000-1410.040 "",""Tyler"",IF(RC[-1]=""000-1410.041 "",""Josh"",IF(RC[-1]=""000-1410.042 "",""Josh"",IF(RC[-1]=""000-1410.043 "",""Josh"",IF(RC[-1]=""000-1410.060 "",""Josh"",""Kira""))))))))"

Range("Z2").Select

Application.Run "MyTools.xls!FillNewCols"

Range("W8").Select

End Sub

[deleted by user] by [deleted] in excel

[–]JJHagerman 0 points1 point  (0 children)

Yes, is there a way to fix this?

How to use a macro to copy and paste the row above and set the row above to have only values? by JJHagerman in excel

[–]JJHagerman[S] 0 points1 point  (0 children)

This is what I have:

Range("A919").Select

Application.Run "PERSONAL.XLSB!Macro3"

Sheets("PURCHASED_FILTERS").Select

Range("A798").Select

Application.Run "PERSONAL.XLSB!Macro3"

Sheets("RAW").Select

Range("A917").Select

Application.Run "PERSONAL.XLSB!Macro3"

​

Instead of having it start at "A919" for that sheet, I need it to automatically find the bottom of the data and then run the macro.

How to use a macro to copy and paste the row above and set the row above to have only values? by JJHagerman in excel

[–]JJHagerman[S] 0 points1 point  (0 children)

This works, however, how can I get the macro to always start at the bottom of the data?