Deleting Worksheets With Macro?

May 2, 2014

I am trying to write a macro that takes the value in cell B2 from a workbook called ""numbers" in a worksheet called "summary," and creates a new worksheet in a workbook called "filestransfer" that is named the same thing as the value in cell B2 from "numbers." That part is done.

View 2 Replies


Deleting Worksheets

Jan 29, 2010

I am trying to write a macro that will look through all the worksheets in my workbook and delete any that are called "Data2", "Data3",... "Data#"

So basically I want to find any sheet that has Data and a number after it (with the exception of "Data1") and delete it. Does anyone know of any way to do this?

View 9 Replies View Related

Deleting Worksheets Not Between Beg And End

May 10, 2006

Would anyone have a way to delete worksheets not between worksheets called Beg and End? I am actually looking for a way to delete all worksheets to the left of Beg (including Beg) and all worksheets to the right of End (including End).

View 6 Replies View Related

Deleting Columns In Worksheets

Mar 24, 2014

I tried to write a macro for deleting some columns automatically in my workbook

- it will be applied to all worksheets, except two worksheets called "samsung" and "toshiba"
- columns will be deleted from V to AA and AU to AZ in the related worksheets

Please check my attached file and my macro inside it.

deleting columns makro.xlsm‎

View 5 Replies View Related

Deleting Multiple Worksheets

Mar 27, 2006

My spreadsheet involved plenty of importing of data for Analysis. However the spreadsheet get cluttered very often and i have manually delete the data worksheets.

I was wondering whether is there a way of deleting all the worksheets that contains data(I.E someway of protecting my proccessing and display sheets from being deleted, about 100 of them) or isit possible to delete spreadsheet in a loop with the last char being a number as all my data sheets are named xxx1 ,xyz2 etc and none of my other sheets end with a number

View 9 Replies View Related

Prevent Others From Deleting Worksheets

Jun 6, 2006

I'm on a system using Windows XP with several user accounts. It's possible to share a document by putting it in a directory called, unsurprisingly, "Shared files' or somesuch. Anyway, I wish to put one of my Excel spreadsheets into this directory so that other users can see it. The workbook itself has about 10 worksheets and I want other people to be able to edit only one of them. So I used the "Protect Worksheet" option within Excel to protect those worksheets I don't want edited. However, I notice that it's still possible to delete a worksheet even though its protected. Is there a way to prevent from deleting worksheets?

View 2 Replies View Related

Conditionally Deleting Lines On Multiple Worksheets

Jun 17, 2014

I need to delete line if 2 conditions are meet.

If col A is blank and col D or E is blank then I want the line deleted for lines 1no more than 100 The option of D or E has me stymied I end up with it not working right. This is what I had tried

Dim lastrow As Long, c As Long
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
For c = 1 To lastrow
If Range("a" & c).Value " " and Range("d" & c). Value " " or Range("e" & c)Then ActiveSheet.HPageBreaks.delete
Next c

But doesn't work

I also need macro to run multiple worksheets which varies anywhere from 12 sheets to 50 sheets.

View 6 Replies View Related

Loop To Delete Worksheets Stops After Deleting One Sheet

Mar 17, 2014

Sub DeleteSheetsPlease()

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
Application.StatusBar = "checking " & ws.Name

[code] .......

This skips "Parameters" and "About", then it deletes a single sheet (that does not match "Parameters" or "About"),

BUT THEN IT STOPS, leaving "deleting [WSNAME]" in the appstatus. It's like it skips the "Next ws" statement altogether after deleting a sheet.

I want it to keep looping on all the sheets, but that delete action seems to kill the looping...

View 2 Replies View Related

Deleting Multiple Worksheets And Saving Active Worksheet

Aug 3, 2007

I am trying to find a easy way to delete multiple worksheets in a workbook and then saving the workbook based on the tab name of the worksheet.

View 9 Replies View Related

Avoid Delete Prompt Deleting Sheets/Worksheets

Aug 9, 2006

whenever you want to delete a sheet, excel would prompt you to ask you if you are sure you want to delete the sheet. im making a vba so that the sheets will delete upon workbook close, but i dont want to be prompted everytime to be sure to delete it when running the vba macro. Also, i would like to avoid being asked to save any changes to my workbook

View 2 Replies View Related

Deleting Multiple Worksheets Which Ends With The Word Data Through Vba Code

Jun 14, 2007

I have many worksheets which ends with the word " data". Is there a way to delete all the data sheets at one go through VBA code.

View 3 Replies View Related

Deleting Rows With Macro

Mar 19, 2009

I want to delete every second row, because I have data with 0.25m interval and I want 0.5m interval. Why I try the following it doesn't work?

View 2 Replies View Related

Deleting All Sheets Except One (macro)

May 8, 2012

I need a simple macro to delete all sheets in a workbook except one that is called "START"

View 9 Replies View Related

Deleting Rows Using A Macro

Jul 25, 2012

I'm looking for a macro that will delete a row with a certain value (0.00) and the row below it.

View 9 Replies View Related

Deleting Folders Within A Macro?

Aug 23, 2012

So I have a macro that creates a monthly set of reports, but some of them only relate to period 5 onwards. I wanted the macro to check whether a folder exists for periods 1 to 4, and if so, delete the folder and all the files inside it. I've used the following...

If Period < 5 Then
If Dir("I:AcctsCentral EngineeringEngineering Reporting Pack2012-131 April 20122-2 Reports - 4+8 Reforecast") "" Then Kill "I:AcctsCentral EngineeringEngineering Reporting Pack2012-131 April 20122-2 Reports - 4+8 Reforecast[code]....

but the macro just skips straight through the secondary IF statements without stopping.

I know this works on deleting files, and presumed it did too for folders, but it doesn;t.

View 2 Replies View Related

Setting Up Deleting Macro

Oct 19, 2013

I'm trying to delete both rows of the same data not just one.






What i need is if there is a same location delete both rows and i cant figure it out to get it to do both of them not just one row.

View 9 Replies View Related

Deleting With For Loop (Macro)

Jan 2, 2014

I have a problem with the following macro:

Sub CalcsDelete()

Dim count As Integer
count = 1

For count = 1 To 100

ActiveSheet.Shapes.Range(Array("Picture " & count)).Select

count = count + 1

Next count

End Sub
It should simply delete picture 1, picture 2, picture 3, picture 4, etc. The problem lies within the "Picture " & count part.

This is obviously the name of the picture, i.e. picture 1, picture 2, etc.

That's what I tried to accomplish with the for-loop, but I'm not sure how to increment the number of the picture by means of using a for-loop and having that be the new name for the picture.

View 6 Replies View Related

Deleting Macro Buttong After Use

May 20, 2008

how to remove a macro button from the sheet after we've used its functions.

For example, i have a macro that emails the workbook. Once the emailed workbook is out, i would like the macro button to be removed after we press it.

View 9 Replies View Related

Deleting Rows With A Macro

Jul 28, 2007

I am looking to find and delete email addresses in this case * I have only one column which is full of email addresses, I just want to delete all of the ones in this case. This is the macro I am trying to use, but it does not work.

For Each cell In Range(Range("a2"), Range("a65536").End(xlUp))
If cell = "*@aol" Then
Range(cell, Cells(1, Rows.Count)).EntireRow.Delete
Exit For
End If
Next cell

View 3 Replies View Related

Deleting / Disabling Macro Once Macro Run?

Feb 18, 2014

I have a couple of macros in the book that plug through a list of "stores", input the store number in a cell, then copy the results to a new workbook, value out the formulas, and save it, before moving onto the next store. There are also 2 types of stores, "STORES" and "CORPORATE", and the sheet toggles some things based on this input. One of those things is a "ON CHANGE" macro that hides and unhides rows appropriately. Everything works in my Master sheet, but the problem is that once I copy the page (and the macro embedded) to a new workbook, I save to a lower version of Excel and it all gets hung up on the embedded macro.

Is there a way to disable/delete the macro once it goes to the new book? I've tried "Application.EnableEvents = False" and i think this is the right route, but i think maybe i'm placing it in the wrong place(s).

Here;s my code:

' PY12 Macro


View 3 Replies View Related

Speed Up Macro Deleting Every Nth Line

Jul 4, 2012

I am dealing with data sets from various instruments that have different sample rates. I am deleting data points I don't need from some of the sets with higher sample rates so that all the data is on the same time scale.

The macro I have is super simple, but incredibly slow. I'm simply deleting every other cell down a column.


Sub OATcondense()
Application.ScreenUpdating = False
Do While ActiveCell <> ""
ActiveCell.Offset(1, 0).Delete Shift:=xlUp
ActiveCell.Offset(1, 0).Select
Application.ScreenUpdating = True
End Sub

View 9 Replies View Related

Macro For Deleting Whole Row Even If Single Data Is Not Available

Apr 2, 2014

I want a macro which can detect empty cell in rows and can delete whole row in which that empty cell is .and want to shift rows up. Macro should start searching empty cells from Column B meaning that It should not delete cells in Column A.

And I want this function in all sheets except parent sheet at position 1.

File is attached : inquiry 3.xlsx‎

View 6 Replies View Related

Deleting Empty Lines Using A Macro

Aug 7, 2014

I have another report which needs to be sorted using a macro. However, before I can sort the data, I need to delete rows at the bottom of each report that have "0" values in column A and B. Again, each report I run is of different length so I need to write a code that will take that into consideration. Here is an example of what I need to do:

Sub second_step()
' second_step Macro

Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
End Sub

Now, the thing is, not every report will start having "0" values in row 7876. How do I write a code to reflect this?

View 9 Replies View Related

Deleting All Series In Graph Using Macro..

Oct 26, 2008

I want to delete all series which are in graphs. is there any way so that i can pull total number of series in VB from graph, and then just do all the series one by one.

View 2 Replies View Related

Deleting Filtered Fields Via Macro

Nov 6, 2012

I have an issue with trying to write a macro to apply a filter and then delete all lines.

Within the macro I copy and paste one sheet to a new one, and Paste Special Values over all formulas, leaving me with a column that has some figures and some "#N/A".



So I need to do something in the macro that then applies a filter on this column and deletes off all the #n/a results.

This table has a number of columns not just this one so it is the full rows that need removing.

I see on other posts that using a range.specialcells clause could work, but i'm not too sure exactly on how to apply this.

View 1 Replies View Related

Macro Code For Deleting Blank Row?

Jan 23, 2013

I've a file with lots of data. In that file I've some blank rows, I want a code which search complete blank row and delete.

View 2 Replies View Related

Macro Deleting Rows Summing To Zero

Jan 20, 2014

I want to write a macro that would delete the rows if the sum equal to zero and the description is identical. For example:

Column a: Column b:
100 Apple
200. Apple
300. Grape
-100. Apple
-200. Apple
400. Cherry
-400. Cherry

The answer should be 300 grape.

View 2 Replies View Related

Macro Deleting Merges Rows?

Apr 18, 2014

I am looking for code to put in a macro that will go through a tab of data and delete the rows that have merged cells in them. The number of rows that there will be will never be a constant because the people using it will be pasted in information from another source, deleting the lines that have merged cells then run a macro with stuff that needs to be done to the info, but I would like to save them the step of delete the rows that have cells.I think it is Office 2013 I am using. I am not at that machine right now so I can't check.

View 4 Replies View Related

Deleting Cells With Keyword Macro?

Jul 23, 2014

So I have data that I'm importing in rows 1,2 and 3. The first row has the product type, then rows 2 and 3 have additional info pertaining to that product. I was wondering how I would write a macro that could identify entries in the first row that equal a particular product, and remove those cells, along with its respective info in rows 2 and 3. Ideally, I could just push a button, and a particular product along with all it's info would disappear from my imported table.

View 4 Replies View Related

Macro Is Deleting My Entire Sheet

Nov 15, 2006

Sub Delete()
Dim x As Long
For x = 28 To 8 Step -1
If Range("b" & x) = "" Then _
Range("b" & x).EntireRow.Delete
Next x
End Sub

View 9 Replies View Related

Copyrights 2005-15, All rights reserved