thing

  1. L

    cells.value vs cells.formula

    Hi In this code, I do not see any difference between cell.value and cells.formula when it comes to entering a formula. They both did the same thing. Am I right? Is there any case, I have to use cells.formula instead of cells.value? Thank you very much. Sub insert_formula() Cells(11...
  2. S

    Remember the last thing copied

    Hello ppl! I googled my problem before posting but couldn't find anything helpful so i decided to ask here. Is there an option to remember the last thing i copied and paste it after doing several actions in between ? For example > I have to copy some text and paste in one cell, than i change...
  3. L

    workbooks.add, open and close

    Hi Can I say workbooks.add is the same if you open Excel program -->New ? same thing workbooks.open is the same if you open excel program --> Open Also, workbooks.close is the same thing if you click on [x] to close Excel program? Thank you.
  4. S

    Sumproduct help

    Hello I am trying to accomplish a sumproduct sort of thing and almost have it but not quite yet. I have cobbled together this formula... =SUMPRODUCT(IFERROR((G10:G8841>I4)*(H10:H8841="Auto")*(I10:I8841>0),)) array entered. At issue is the fact that cells in column G may contain numbers (a...
  5. A

    Can't make it work?

    I need one more thing <d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8="">=IF(H8< D2,"In Darkness",IF(H8=D2,"Under Light",IF(AND(H8> D2,H8< F2),"Under Light",IF(H8>...
  6. A

    Need a little more help

    I have this formula <d2,"in darkness",="" if(h8="D2,"Under" light",="" if(and(h8=""><f2),"under light",="" if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""> <d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in...
  7. A

    Vba for each cell in rng insert dynamic formula

    Hi all, this might be simple but can’t get my head around it. i would like to put a formula into each cell within a range (B2:AZ517) Then paste the value then move onto the next cell. The only thing is that the formula contains references e.g. row 1 and column A must stay constant. for...
  8. S

    Data Validation

    I have been trying to research this but can not get anything to work. I am trying to use a data validation list that shows 1 thing but puts another thing in the cell. For instance I would like to see A in the validation list but when I click A the cell value shows 111. Hope this makes sense...
  9. albertc30

    dropdown list in alphabetical order data validation...

    Hi all, again... I have been reading on this and have found a few good youtube videos. One in particular mentioned 4 ways this could be achieved, the best way being the new function SORT. Sadly, this is not available on my newly bought office 2019 professional. Just another way Microsoft has...
  10. DataBlake

    Loop each sheet between two sheets

    so i'm trying to loop between sheets in between my sheets "Program Start" and "ID check" and if hidden sheets matter it would be between "Program Start" and "Master Image" i.e the loop logic would be: for each sheet between ProgramStart to IDcheck 'do a thing else 'do a thing next sheet the...
  11. I

    Creating sunburst charts

    Hello. I try to make a chart, but I have a problem I can not solve. I need a little help and I'd be glad if you help me. The chart should look like I did in the picture. I divide the diagram into 8 parts, which are divided into five more. My idea is that these 5 parts represent a percentage of...
  12. D

    What is the difference between .clear and .clearcontents?

    What is the difference between .clear and .clearcontents? They sound like they do the same thing.
  13. C

    VBA Find and Replace (whole workbook)

    <tbody> A B A Anderson Alex Anderson B Smith Brandon Smith </tbody> - I pasted my list of names in sheet 1. - I need to FiIND A1 (entire workbook) and replace all instances with B1. - then same thing for A2 to B2 and so on so forth. Thanks in advance
  14. m_in_spain

    There must be a way to shorten this!

    Hi I have some shapes (arrows = called drop1, drop2.... etc) on my spreadsheet, which i want to appear/disappear depending on the value of cell C4. This below works ok but to me seems long winded, especially considering i need to add another hundred arrows or so, and then duplicate the whole...
  15. Jym396

    Entering numbers is very slow

    Workbook with 3 sheets: Timesheet, Charts, Data. ONLY the Timesheet when I enter a number or time, calculation is slow (~5-6 secs). It does not happen with alpha characters. Dimension for Timesheet is A1:AG566 A few vlookups and many if statements. The thing that puzzles me is this happened...
  16. A

    Removing unwanted rows

    Hi all, I am chasing some help please.. I have an excel sheet produced from my accounting system that has every product in rows (over 6k rows) and in column "I" it has a quantity i need a way of removing all the rows with "0" in the "i" Column. I this possible? There other thing is it has a...
  17. J

    Plotting curves or shapes?

    Hello everyone! I've posted before, then later deleted my account, but now I'm in need of your expertise again. I have a calculator called "Chutecalc1" written by a gentleman who used to be in one of my model rocket forums. Anyway, this calculator calculates the shape required for a...
  18. K

    Macro to advance to next value in filtered data?

    Hello, I have a spreadsheet with over 1600 rows of data. In Column A, there are around 250 or so unique values. I currently have column A filtered so that I can just look at the rows with the specific value I want to see in column A. Is there a way to run a macro so that the filtered data...
  19. H

    Help 2 this Formula (if and) or

    Hey Group I need some Help to this formula =IF(And(D9=1;L11=1);D12) That Part Works Fine i now need a "Or function after that Working formula so it might look like that perhaps =IF(And(D9=1;L11=1);D12)or If(And(D9=1;L11=2);D11) i have try that but it wont Work and not for any thing i...
  20. A

    Wee green triangles

    Can they be turned OFF in VBA ? So it saves a User figuring it out and only affects *this" workbook. Thanks for any help. I googled for this and found I'd asked the same thing here back in 2009 but got a not helpful reply. It would be helpful to know if they can't, and I can stop looking.

We've detected that you are using an adblocker.

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.
Go back
Back
Top