i have a code which was written by a freelancer on a dummy file. when i tried to copy the code into my original file, i ran into some error. i understand that the code contains a lot of .select and was advised to rewrite the code.
can anyone help me with that?
Sub Macro2()'' Macro2 Macro
This macro will add 30 seconds to the close process. I can not see why it would take that long.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ScreenUpdating = False
Sheets("START").Visible = xlSheetVisible
Application.WindowState = xlMaximized
For Each ws...
I am trying to export data from a sheet, but when I do, it creates a txt file and renames my workbook the same thing. I just need to have the text file created. Sub export()
Application.CutCopyMode = False