thing

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...

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...

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.

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...

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>...

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...

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...

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...

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...

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...

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...

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

<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

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...

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...

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...

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...

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...

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...

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.