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 RepliesJust 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 RelatedI suddenly can not edit in a cell by double-clicking on it. I can only edit in the fx bar on top. Other sheets in the workbook still work normally. What causes this, how can I fix it and how can I make sure it doesn't
View 5 Replies View RelatedI've been using a Macro that was written in an Excel spreadsheet and it's been working fine. For some reason, the Macro does not work anymore.
The Macro is written in Visual Basic and it is launched with button.
What is the first step I should take to debug this?
I think it's something obvious I'm missing.
A couple years ago i made a giant spreadsheet and had 2 custom toolbars to run macros from to manipulate the sheet.
This year i re-did the sheet, meaning all my old data was replaced (it's a giant schedule basically).
However, the Macros in the custom toolbars stayed exactly the same and performed the same function and are directed to the exact same cells, rows, columns, etc..
But now when i hit the buttons on the custom toolbars to run my macros, i get the following message... all the time...
**
A document with the name "NHLsheet.xls" is already open. You cannot open two documents
with the same name, even if the documents are in different folders.
To open the second document, either close the document that's currently open, or rename one of the documents.
**
Trouble is, i have only 1 document open!
There's something in the macros that thinks i'm trying to open a new document but i'm clueless as to where or why.. they are very simple macros
that do not require the opening of any new workbooks..
All they do is point to another sheet within my open workbook, "NHLsheet", copy a particular row from that sheet, and paste it to a specific spot onto another sheet within my workbook, "NHLsheet".
Here is a sample:
At work we use a connection to a SharePoint List within Excel to refresh the data in the files.
When excel is refreshed I get this error (this happens for all users in the team and multiple workbooks)
Image 1.png
The weird thing is I can export the SharePoint list to an excel file and it is fine but as soon as i go to refresh it (Data>Refresh All) it produces the above error.
Learn about the "copy only visible cells" when I've filtered down a filter. Now Excel copies that way by default everytime I copy multiple rows when I've filtered. But NOW I want to copy everything that is hidden between the filter as well, i.e. how it did it before.
How can I tell Excel to do that?
Microsoft Excel is no longer displayed at the top of the screen, and I can't see my worksheet tabs at the bottom of the screen.
View 3 Replies View RelatedI attached 2 examples. The first one is before the screen flickering fix I got from Andy Pope. The second is when I added the fix. When you open Example List 1 and you enter 0 at E180, the screen will flicker, but it will change (red) Watching to (green) Planning to Watch in G180.
When you open Example List 2 and you enter 0 at E180, the screen doesn't flicker anymore. The status Watching in G180 still changes to Planning to Watch, but it stays red while it has to become green. How can I have the color changes and no screen flickering? Marco:
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
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).
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 RelatedI 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 View RelatedIn 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.
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.
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] ......
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 RelatedHi 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.
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 RelatedThe 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 RelatedIt 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.
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?
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 RelatedWe 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.
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 RelatedI 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 RelatedI 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 RelatedI 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] ..............
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 Relatedin 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"