Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
Question is, line 1 selects a fixed Range but I would like to change this to the equivalent of "Shift + Ctrl + End" ie from current cell to the last cell in the row. End Right won't work because there are gaps.
Range("L1:YF1").Select Selection.EntireColumn.Hidden = False For Each Cell In Selection Count = Count + 1 Next Cell Range("L1").Select For Ch = 1 To Count If ActiveCell.Value <> "" And ActiveCell.Value = 0 Then Selection.EntireColumn.Hidden = True Else End If ActiveCell.Offset(0, 1).Range("$A$1").Select Next Ch Range("$K$2").Select
|+1 to an even value||4||15|
|Top 10 with duplicates in Excel Table||4||13|
|Excel VBA Differences between 2013 and 2016||4||14|
|VBA Code to Uncheck multiple items in a single filter field (autofilter)||6||8|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!