deleted

Hi all - I have a worksheet that contains about 20 WORKSHEET scoped named ranges. Normally, when I delete a sheet with worksheet level named ranges, the named ranges are automatically removed. When I delete this particular sheet - the named ranges are still there - but they are turned into...

Hi I was doing cells.clear then I thought of doing cells.delete. To my surprise, when I click on a button to run the code below, everything got deleted including the button. So I left with a clean sheet. What I thought would happen is that the who sheet will get deleted and also why the control...

Hi everyone, I got this listbox named lstSearchResults. The data in it comes through VBA from the worksheet "Telephone". I would like to have a button to delete items in the listbox that i select. I found this code; Private Sub cmdDeleteContact_Click() Dim i As Long With Me.lstSearchResults...

For this little guy: =SUM($A$2:INDEX(A:A,ROWS(A:A))<wbr style="font-family: Arial, Helvetica, sans-serif; font-size: small;">) The only reason a simple =SUM(A2:A10000000000000) won't work is because too many lines are getting deleted with each update, and I'm trying to avoid having to check if...

I have made two buttons that will add and delete the last column of data, but when I delete the column other cells that have formulas linked to the last column of data are also deleted. Is there a way to make it so that the formula is still locked to those cells after the column has been deleted?

Hi, Unfortunately I have deleted table called "Rik" from access table 2010. Now I am looking for suggestion to recover table from the access 2010. Please suggest. Thank You, Mohan

So yeah I used basic cell reference to other workbook, then I deleted this workbook, but numbers stayed ? When I try renter this formula, all it asks me is to find file path, once I cancel it just take numbers from deleted file. I was expecting it to give an Error..

I have been using a process outlined on the tech republic website (see link below) to highlight the selected row from column A to column L. In general the process works great, however I have found a problem. I don't know if the problem is with the process, or if it is with Excel 365...

I would like all duplicate files on Col A on sheet3 ending in .xls to be deleted march sales.xls march sales.xlsm sept sales.xls I only want march sales.xls to be deleted Your assistance in this regard is most appreciated

I have 2 sheets in the same workbook where I need to exclude/delete rows in one sheet when the values are not found in the second sheet. The two sheets are imported from downloaded workbooks. The result is a workbook that has two sheets where Sheet1 may have rows that need to be deleted...

I have two workbooks that are a mirror image where workbook A feeds workbook B that part is done, but what I am wondering is if it is possible for the information in workbook B to be locked so in the event the data in workbook A gets deleted it wont be deleted in workbook B?

Hi, I wish to delete a photo when the worksheet is closed. My code that runs when i close the sheet is supplied below. I have just run the code and noticed that on the sheet DR PDF it has deleted the command button 1 & 2 The code is still on the sheet but the 2 buttons are gone. HAVING SAID...

Every since updating to Excel for Mac Version 16.18 (181014) recently, everytime I open Excel I receive an Alert saying "Sorry, we couldn't find Personal Macro Workbook. Is it possible it was moved, renamed or deleted?" I haven't moved, renamed or deleted it it. It has been in the same folder...

Hello, I'm trying to isolate/ignore the values that get entered in a cell in order to keep things neat within the program I'm making. Currently, I have multiple values in "Sheet1" going into "Sheet1 Data" with the use of a VBA Macro. These values are then compared to other values within the...

Hi, I have been looking at a lot of event change codes but none seem to work... i would like the event change to fire if rows or columns are deleted and if they have been deleted then set the new Range as ActiveSheet.UsedRange to get the true range of cells. I have tried enabling and disabling...

What is the vba code I can add to a button to delete last row from a table?

Hi All, I would appreciate some help with the following problem: I have a workbook (using Excel2013) with ca. 20 named worksheets of which I would like to delete approx. 10. Having earmarked these 10 sheets for deletion, I just want to check if the Worksheets which will not be deleted, are...

Hi all this is just a general question re what drives files size in a Power Pivot model. I need to share my files with other users so they need to be as small as possible as most users only have a basic computer set up. i have created a file with only a very small amount of data in the data...

I have a macro that is deleted once rows are deleted using a macro. I would like if there is a way for the button to appear on the sheet once the rows are deleted

Hi there, I have a shared workbook with 4 sheets that must not be deleted. I want users to be able to view, add and make changes, but people have already deleted these sheets in error and we've had to restore the workbook from an older version. Other worksheets will be added and those can...