We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Dim fName As String, Report As Workbook Set Report = ActiveWorkbook fName = Report.Worksheets(1).Range("A11").Text & ".xlsx" If IsOpen(fName) Then MsgBox "Good, file opened." .Sheets("Input").Range("B8:O11").Copy .Sheets("Avg Daily Vol").Range("G5").PasteSpecial xlValues Application.CutCopyMode = False MsgBox "Values pasted successfully!" Else MsgBox "Today's report is currently not opened." End If
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Word 2016 Workgroup Template GPO not applying.||6||26|
|How do I combine these two formulas in one cell in Excel 2007 to get them to work?||4||31|
|Excel VLookup in a macro where returned column changes every month||7||12|
|Conditional Formatting from zero to a specific negative number||2||14|