Posts by Paulo Cordeiro • 7 points
3 posts
-
0
votes1
answer42
viewsQ: Add exception in Cell.Delete
I was using this Sub Clearcontents to clean up all the content I had in the Sheets, I need to add an exception that is the G1 cell and I found this other Sub, but I don’t know how to mix the two Sub…
-
-1
votes1
answer44
viewsQ: Modify Sheet killer to just clean sheet content and not erase it completely
I’m using the following code I got here on the site Sub Listar_Pastas() '''''''''''''''''''' '==== Pastas ====' '''''''''''''''''''' Application.Calculation = xlCalculationManual…
-
0
votes2
answers581
viewsQ: Create a spreadsheet with folder names listed from a directory in excel
I’m using this code to list the folders that contain some names I need to spreadsheet. Option Explicit Sub CreateList() Application.ScreenUpdating = False Workbooks.Add ' create a new workbook for…