Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
Sub GetDate() 'Ask for a date for the new report, insert a new sheet and insert the 'date in "B4", "D77" and name sheet with date. Dim FormDate As Date FormDate = InputBox("Which Date to use?", "Form Date", Date) If FormDate = True Then ActiveSheet.Move After:=ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count) ActiveSheet.Copy After:=Sheets(Sheets.Count) Range("B4") = FormDate Range("D77") = FormDate ActiveSheet.Name = FormDate End If If FormDate = False Then Exit Sub End If End Sub
|Extract strings / characters from the right till the first occurrence of a comma, using an excel formula||6||31|
|How to pull text from inside a formula in Excel 2010?||6||26|
|Search multiple lines||3||25|
|Input information on K column using userform.||15||14|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!