I have created a clear button on my sheet to reset certain cells to 0 etc.
However in some of the cells formulas are also being deleted. Can someone tell me how to correct this problem, leave the formulas intact.
Thanks all
GT
Greeting - is it possible to just lock columns A, B & C from being edited, but still allow rows to be added or deleted? I using Excel 2016.
Many thanks in advance for any assistance.
Is there a way to lock the return value of a formula. I need my vlookup formula to return the value and leave it unchanged because the data range vlookup is pulling from will be deleted on a daily basis.
Any and all help is appreciated.
Thank you.
Hi,
This is part of my code:
.Range(.Cells(2, 1), .Cells(2, 1).End(xlDown)).AutoFilter Field:=1, _
Criteria1:="xxxx"
.Cells.SpecialCells(xlCellTypeVisible).EntireRow.Delete
This code will also delete the first row (header) in my sheet. Is there a way to exclude the...
Hi all,
I was just wondering if anyone new a macro that deleted specific tabs based on part their name. I have a macro that creates new tabs, but every tab has "Sheet 1" in it, the later tabs have "Sheet 1 (2)", "Sheet 1 (3)", etc. I just need those tabs to be deleted at the push of a button. I...
Hello,
I use a workbook with around 3 Macros (No use as of now), it had around 8 tabs. The file size is around 3.30 Mb.
This workbook is used to add products into our CRM system (after saving it to CSV) however this workbook is full of calculations (at least 30 columns which is automated using...
Hi.
I am sure there is a very simple solution to this. I have a list of names across rows, underneath is a number (starting at 1). What I want to do is to have a formula that means even if a column is deleted, the number adjusts itself so that it all runs correctly.
The formula that I...
Ok, so one of our executives often works on excel files straight from email - in other words, he opens an excel file straight from an email and DOES NOT save the file before making changes. He will have 20 excel workbooks open all in READ ONLY status. Well, he worked on a READ ONLY file for...
Hello,
I am getting an error message which states
"Sorry, we could not find C:\Users\Simon\Downloads\QuotesAddIn64.xll. Is it possible that it was moved, renamed or deleted"?
This file was for an add in that I unsuccessfully tried to install. I have searched my PC for the file without...
I am using the below formula but always get a reference error when I delete row 14. I always want it to reference C14 even if the row is deleted. Any idea how to incorporate an absolute or index in this formula?
=EOMONTH(C14,0)
Thank you to anyone who can answer this!
Deleteselected Range in selected Sheets
Cananyone help with a code that deletes a Range starting in "A7" to bedeleted in all Sheets except two in the workbook?
Rangecan vary in number of Rows.
Afterall Sheets are deleted, cell "A7" must be active on all sheets thathave been deleted...
Hi,
I have this code in various cells,obvioulsy each with a different cell reference.
=IFERROR(VLOOKUP($B12,INDIRECT("INFO!$CV$2:$DB$"&COUNTA(INFO!$CV:$CV)),5,FALSE),"")
I select a customers name in cell B then VLOOKUP populates cells C D & E
Now column D refers to how much the customer has...
Hi all
I would like a word to be inserted into a cell if it is blank.
Example:
If A1 has any value in it and it is deleted and A1 is blank, the word "Spare" will appear.
Thank you!
Hello,
I one last issue I am trying to solve to complete my project and I am at a loss on how to fix it.
Sheet1 = "Inventory Value Report" - I am using this as an "import tab" where a new value report is pasted every time it needs to be used.
My issue is that the first macro that runs...
Hi folks,
I have a macro that allows users to delete certain worksheets from protected workbooks.
The user is not allowed delete any worksheet that exists in the template.
However, there is a macro to allow the user to add a new sheet and rename it whatever they want.
They are allowed to delete...
I have a table. I once had a formula in one of the cells. I deleted the formula. I go to copy the row and past it the formulas re-appease in the new row.
Why? I keep having to delete the same formula over and over.
Thanks
How can I create a macro to delete many columns.
I need the below columns deleted. I tried but failed....
Range("B:S,C:C,E:E,G:G,I:I,K:K,M:M,O:O,Q:Q,S:S,U:U,W:W,Y:Y,AA:AA,AC:AC,AE:AE,AG:AG,AI:AI,AK:AK,AM:AM,AO:AO,AQ:AQ,AS:AS,AU:AU,AW:AW,AY:AY, _...
Hello,
I want a zero number in the cell A1
When a data was entered in the cell A1
I deleted it later
The zero number is entered in the cell by default.
Thank you in advance
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.