deleted

Hi, I have a workbook which is running very slow in just one worksheet. It is almost unworkable. I cannot scroll, the page constantly freezes and occasionally the workbook crashes. When it does work I can use the other worksheets without any issue. The worksheet in question has a lot of...

Hi, I'm not sure if this is doable. I have a Validation list in column D. If Column D = "Cancel" than I would like for that row to be deleted, and the other rows copied and pasted to fill the blank row. My list only goes from rows 5:30 and i have data under the list, so i don't want the...

Hi, I am currently working on a sheet where I would need to prevent Columns A to G from being deleted. However, I should still be able to edit cell content in Columns A to G. Anyone has any solutions, perhaps using VBA, on how to tackle this? Many thanks in advance!

Hello All, If I have a tab labeled "Home", how can I lock the tab so it will not be able to be deleted, with out simply hiding it? And, I still want to be able to work on the Home Worksheet, just not be able to delete it. Thanks excel 2013

I have text total in Col A I need a macro that where there is a zero in the same row as "total" in Col A , then all the columns containing the zero in the same row as Total to be deleted Your assistance in this regard is most appreciated

I have spent several weeks trying to understand why a particular spreadsheet we have takes around 5 minutes to open. Doubleclicking the excel file shows the normal Excel 2013 splash scren. It immeditely shows it has opened at 100% The familiar Excel splash screen will now whirl away from...

Hello All, Is it possible to prevent a tab, in a workbook, from being deleted, with out hiding it? Thanks

Hi All, I have a list box where the row source comes from a name manager range, I would like to delete a specific cell (All in column "A") and this will clear the row due to the code. However there are a number of rows that are generic that i do not want to be deleted, but if the row selected...

Hi, Please can someone help me? I would like code that once 1 cell has been entered in a range, the rest of the range enters a "C". So basically my range is D5:D15 If the operator enters a "N" then nothing happens. If the operator enters a "Y" then the rest of the cells in the range auto...

Hey all, I have two columns, A and B. Column A has certain words pertaining to codes, column B has the codes. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Change Code Deleted 10021 Added 10022 10060 Deleted 10061...

I have a file with an external link that I can't locate, break or delete. In fact, I isolated the link to one particular tab, deleted all of the other tabs, and then deleted all of the content on the "corrupted" tab and it's still there. I'd love to post the file in case someone knows how to...

Hello, Is the above possible in VBA code for a sheet? So allow data to be overwritten but not deleted? Many thanks.

Hello! This might be an easy question, but i hope you can help. In an earlier thread i asked for some help regarding a code that will check two columns for duplicate values. Both the values in the same row of the columns has to match the values in a row somewhere else in the columns. When such...

I'm a real newbie when it comes to VBA and macros so apologies in advance if I'm using the wrong terminology in some of this. I've created a workbook called a Job Sheet Generator. We use this to enter information about a particular job which when we click on a button, saves the workbook as a...

Hello! I would appreciate help with some VBA code. The code has to check two columns for duplicate values. both the values in the same row of the columns has to match the values in a row somewhere else in the columns. When such a match is found the bottom most row should be deleted. To...

Good morning, I have the following code sitting behind the scenes... Private Sub Workbook_Open() Dim strFolderName As String Dim strFileType As String Dim pasteRange As Range Dim returnVals As Variant '// set parameters, change as required strFolderName =...

OK now I need to detect when the data in any 2 adjacent cells in columns B and C are both equal to zero, and then delete that row. For example, below I would want to have row 35 deleted. Excel 2010 32 bit <tbody> B C D 29 1:53:30 113.50 0.500 30 1:54:00 114.00 0.500 31 1:54:30 114.50...

Hey Guys, I have puled up an old sheet and need to make some changes and additions, but i have done something i cannot remember how to undo. to the right of the last column of cells i was working in and below the last row of cells I removed the additional cells. I hit shift+ctrl+ arrow key...

Hello Guys, I have two scenarios need to be solve with IF conditions. In my sheet1 I column cells i have a string which consists of alphanumeric and symbols. I am in the process of cleaning up the strings. I cant fix these 2 cases. Please heads up and help. 1st case: If any cell in I column has...

Hi, I have written the below code to search a value and if found remove the entire row and if successful pop a message advising the record has been deleted. I have two problems: 1. When there is no data the message will still pop up confirming something has been deleted which isn't the case...