Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sub CopyRws() Dim rng As Range Dim intCols As Integer Dim introw As Integer Set rng = ActiveCell.CurrentRegion intCols = rng.Columns.Count introw = ActiveCell.Row Range(Cells(introw, 1), Cells(introw, intCols)).Copy Sheets("LogArchived").Select Range("A7").PasteSpecial xlPasteAll Sheets("TaskTracker").Select Range(Cells(introw, 1), Cells(introw, intCols)).Delete xlShiftUp Set rng = Nothing End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel ActiveX ComboBox enters a 0 if a list item isn't selected||41||42|
|Compare Excel spreadsheet - 1||3||37|
|Excel formula that pulls back the id||4||40|
|Some sheets won't re-calculate unless you stop and step through the code||3||13|