Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
Assistance is greatly appreciated!
Sub Make_Non_Macro_Sheet_From_Tab() 'This sub is intended to create a separate sheet from the active tab.' 'It will prompt for a file name with the current users desktop as the default,' 'remove empty tabs from the newly created sheet, and ensure that it is macro free.' dtpath = CreateObject("wscript.shell").SpecialFolders("Desktop") Set wb = ActiveWorkbook Set ws = wb.ActiveSheet wb.Worksheets.Add ws.Cells.Copy ActiveSheet.Cells ActiveSheet.Move fn = Application.GetSaveAsFilename(dtpath) If fn <> False Then ActiveWorkbook.SaveAs fn & "xlsx" Else MsgBox "file not saved" End If End Sub
|VBA to delete range of cells in row NOT entire row||11||32|
|Protecting an object||3||24|
|Cannot get VBScript to run as schedules task||10||18|
|Why Excel table refuse some basic editing ?||3||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!