Delete Worksheets With Only One Row Of Data

Feb 10, 2008

I need really is code and I'm sure it's only 4 -6 lines long. Ok, I need to do a simple task, don't ask why (as always, that's just a long needless explanation) but pretty much, all I need to do is delete each worksheet that has only one row in my workbook. All the other worksheets (for example if they have 2 or more rows) leave them as they may be and let them live.

View 4 Replies


ADVERTISEMENT

Delete Only Blank Worksheets With No Data

Sep 6, 2006

I have a problem here.I have a excel work book which has more than 100 work sheets in it. First i will run a report in Business objects and then save the report as excel work book. Now here is my question.Is there any Macro which searches for blank work sheet from the 100 work sheets and delete it automatically.

View 5 Replies View Related

Loop Through Worksheets Not Working (delete Some Hyperlinks In Column A On 50+ Worksheets)

Jan 16, 2009

Just need to delete some hyperlinks in column A on 50+ worksheets. Thought a loop through all the worksheets would do it. Only works on active sheet. Forgive my ignorance, don't really even know where it goes, once it works - module or workbook?

View 2 Replies View Related

VBA: Cannot Delete Worksheets Anymore

Jan 26, 2010

i've been programming a bit in excel and quite new to the whole thing but managing nonetheless... however, after having built a couple of macros in excel, i can now no longer delete all the worksheets listed at the bottom of the workbook.

View 9 Replies View Related

Delete Worksheets Based On Name

Feb 24, 2010

I have 50 worksheets..

I need to delete any worksheet that does not have the word ( FINAL ) in it ( minus Sheet1, and Worksheet Names ).

I am thinking of this...

Sub Delete_WS()
For Each ws In Worksheets
Select Case ws.Name
Case "Sheet1", "Worksheet names"
Case Else
''''' NEED HELP WITH CODE"""""""
End Select
Next ws

End Sub

View 9 Replies View Related

Delete Worksheets With Specified Prefix

Nov 7, 2009

I have several excel workbooks with many worksheets (over 500 in some). Around a third of these worksheets are named "Exp1", "Exp2", "Exp3", etc.

I would like a macro that will delete all worksheets that do not have names starting with the letters "Exp". I do not want any confirmation dialogue, and as the workbooks vary in size, I would like it to finish when there are no sheets left (except the Exp ones of course).

View 3 Replies View Related

Delete Worksheets Not Named X

May 29, 2007

I need a marco which when executed must delete all other worksheets except the worksheets named "Report" and "Query" . I know the code for deleting a selected sheet but how to write this one ?

View 3 Replies View Related

Excel 2010 :: Sort Worksheets Alphabetically And Keep The Data In Worksheets

May 15, 2013

I have read that there is a VBA macro in F11, but I also read that it would only sort the workshhet names, but not the data. I have Excel 2010.

View 2 Replies View Related

Delete Middle (same) Worksheets In Many Workbooks

May 8, 2014

In the attachments is the original format of the workbook, but the sheets are blanco. Did this on purpose, because the info is sensitive.

Is there a method to delete the middle sheets, 'Total1999' and 'Klad1'?

Is there a VBA code do this in a lot of workbooks, the format of all these books are the same.

Plus I'll place them in one map if it's necessary.

View 13 Replies View Related

Delete Worksheets Not Visible In Range?

Apr 9, 2014

I have a macro solved on another post that creates worksheets based on a Range and renames the new worksheet to the corresponding value. The range is edited on a regular basis, so to keep the file size down I need to remove any worksheets that no longer have a corresponding ID in the range.

The previous post is here

HTML Code: 

Sub CreateTimeline()
Dim rng As Range
Dim rCell As Range

[Code].....

I'm sure that I could amend the above code (also removing the copy worksheet condition) to check the worksheets and delete any that no longer have no corresponding value in the range from the worksheet name.

View 4 Replies View Related

Delete Worksheets Using Checkboxes Macro?

Oct 13, 2008

I've altered a Print Worksheets Macro from the web to allow me to choose which worksheets I want to delete by selecting a checkbox. For some reason, though, the macro almost always deletes the last worksheet as well as the one selected.

[Code] ......

View 3 Replies View Related

Delete Worksheets Using Checkboxes Macro

Oct 13, 2008

I've altered a Print Worksheets Macro from the web to allow me to choose which worksheets I want to delete by selecting a checkbox. For some reason, though, the macro almost always deletes the last worksheet as well as the one selected.

View 2 Replies View Related

Delete Duplicate Rows Vb Needs To Run On All Worksheets

Apr 20, 2009

Hi i have the below code which runs on deleting duplicate code which i found in an excel manual. I am having some trouble as i want to convert the code so that it will run on all worksheets i have which are numbered such as 1,2,3,4 etc.

This is so it makes the workbook easy maintenance for when deleting or adding worksheets which happens quite regularly.

View 7 Replies View Related

Delete Rows/columns Across All Worksheets

Jun 24, 2009

I have a single workbook with 55 worksheets. I need to delete rows #1-14, then delete columns A & B on all worksheets. The macro below seems to be running in a loop which appears to delete rows 1-14 and columns A & B until there is no more data left on the active sheet only. It does not run on any of the other sheets - even if I select all sheets before running the macro.

View 4 Replies View Related

Looping Through Worksheets: Null Value Or 0, Then Delete The Row

Jan 5, 2010

The code should go through each worksheet and if the row in column A has a null value or 0, then delete the row. The count is based off of column T. The row deletion portion of the code works, but something is wrong with my worksheet looping structure.

View 5 Replies View Related

Macro To Delete Hidden Worksheets

Jul 11, 2008

It would be great of I could delete all but one of the hidden worksheets. It would be perfect if I could tell the macro not to delete one of the hidden worksheets (called "Test O2 and CO2"), but if that is too difficult, then just one to delete all the hidden sheets would be fine.

View 9 Replies View Related

How To Delete Worksheets ( Based On A Name In Range)

Aug 20, 2008

I have a "Temp Sheet" with a range in Column A:

ColumnA
Invoice #
S9700441

it will always be at least one but could be well over 100.
I have a code that creates a new tab for each invoice #.

But now I need a code to delete them.

Is there a way to delete worksheets based on a range?

View 10 Replies View Related

Merge Worksheets And Delete Duplicates

Jan 11, 2007

We receive huge Excel files and we need to validate for and delete duplicate records before they are imported to a software product called Exceed Premier. We are having a difficult time with Excel spreadsheet duplicate record validation because we have to first export the files from the Exceed database into an Excel spread, merge the thousands of other new records from multiple Excel files, then import back into Exceed.

Is there a method in Excel/VBA that can merge several worksheets and check for and delete duplicate irecords? The records will be in the 20-50K range and growing.

View 3 Replies View Related

Delete Specified Column In Multiple Worksheets

Dec 2, 2007

book1.xls has many worksheets and I need to delete col4 of each one. Any suggestions as to using a macro or VBA? Or any other shortcut?

View 5 Replies View Related

Delete Worksheets Depending On The Number Of Rows?

Jul 1, 2014

I have a workbook has many worksheets, I would like to be able to delete worksheets if, for example, the number of rows in the worksheet is less than 100 rows.

View 3 Replies View Related

Delete All Hidden Worksheets When Workbook Saved

Oct 15, 2008

I have working code to unhide specific worksheets from a large number of hidden worksheets and would like to be able to delete all the hidden sheets when the workbook is saved or maybe have a button to delete all the hidden (un-needed) worksheets beside the selection drop-down menu, so that only the selected sheets are saved.

View 4 Replies View Related

Macro That Will Delete Duplicates On Entire Worksheets

Dec 29, 2011

I have a macro that delete empty cells in a column, what i wanted to do is while deleting the empty cells is that the macro will also delete duplicates in ENTIRE WORKSHEETS. My file has so many sheets so i need a macro that run or loop on my entire worksheets.

This is my code. that only runs in a single sheet.

Code:

Sub deleteblanks()
Columns("H").SpecialCells(xlBlanks).Delete (xlUp)
End Sub

[Code] ..............

View 9 Replies View Related

Macro To Delete All Worksheets Except For One Called Main

Mar 26, 2007

Does anyone out there have a macro that will delete all worksheets except for one specific one? In this case I want all worksheets deleted except for one called "MAIN".

View 9 Replies View Related

Delete Rows Matching Cell, Across All Worksheets

Aug 20, 2006

in VBA, I would like to do the following:

Delete the entire row where any cell in that row is equal to cell "b15" in worksheet "Metal Type".
I would like it to run across all the worksheets hidden or unhidden, in the workbook, (except for worksheet "Metal Type").

If possible I would also like it to prompt the user to accept the contents of cell "b15" in worksheet "Metal Type" or enter a new string.

Also can it alert the user when "no matches were found"

View 9 Replies View Related

Delete Nth Row In All Worksheets If Cell Meets Criteria

May 21, 2008

I want to scan all sheets in a workbook and to delete a first row where a value in cell(1,1) is "table".

Sub DeleteFirstRowInWorksheet()
Dim SheetName As Worksheet
Dim i As Integer

For Each SheetName In Sheets
If Range("A1") = "table" Then
Rows("1:1").Select
Selection.Delete Shift:=xlUp
End If
Next SheetName
End Sub

It delete only in an active sheet. What's wrong?

View 5 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

Macro Button - Insert / Delete Across Multiple Worksheets?

Mar 19, 2014

I'm trying to track information pertaining to employees across different worksheets in one excel file. I have one sheet that is the master list of employees. The first column of every worksheet is the same (employees names based on their location) but track different information.

I want to be able to create a macro button that will update all the worksheets if i insert or delete an employee from the master list. When a new row is inserted, the other worksheets should be updated as well with the new name and a blank row to be filled in. And when a name is deleted, the entire row should be deleted as well.

View 2 Replies View Related

Macro To Find Named Worksheets In Workbook And Delete?

Nov 27, 2012

I need macro to find worksheets (tabs) starting with word 'sample' in name and delete all instances of worksheets starting with that word.

View 1 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

Macro Paste Special, Protect, Delete Worksheets

Jul 19, 2007

I am looking for a macro that can do one of two things. I am not sure which way I want to go with this yet and how automated it should be. Either scenario will result in a significant time save.

Scenario One
1. Copy & Paste Special Values on the selected/active worksheet
2. Protect Selected Worksheet with password "1234"
3. Delete ALL worksheets except the selected/active worksheet from the file. Names of other sheets can be various and are not static

For example:
A workbook has the following: sheets1, sheet2, sheet3, sheet_unknown_name
If you are working in sheet1 the macro would copy paste special values the entire sheet, protect sheet1 with the password "1234" and delete any and all other sheets.

Scenario Two
1. Copy & Paste Special Values on the selected/active worksheet into a new workbook
2. Protect the new workbook with password "1234"
3. Rename the new workbook with the original workbook name adding either "em_" to the front or "_em" to the end of the filename
4. File, Send To, Mail Recipient as attachment.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved