understand

Hi everyone, hope you are good! Please note that I am trying to figure out how a formula is working on a spreadsheet that I have. I understand how Index and match work combined, nonetheless, I can see that before the match formula there is a "1" and I cannot understand how it works, in addition...

Hi From Object Oriented point of view, I understand Cells is a property of Range Class and its type is Range. So I understand this code cells.clear but what I do not understand this cells(1,1).value ="hello" Where it says Cells takes Row, and Column as arguments? If you check Range...

Could someone breakdown this formula for me? I did not create it but I need to better understand it and what portions are specific to specific cells...

Hello everyone specially Rick, Last year you posted a macro, and I still trying to understand how it works. I know It is super powerful using Evaluate, but there is not so much info about how to use @ as you did in the macro. Can you please make a breakdown of your code: Sub PrefixAnApostophe()...

Hi I understand both of them but I really do not see when I need to use one over the other. Is there any example that shows we can only use one over the other? Thank you so much.

i have a code which was written by a freelancer on a dummy file. when i tried to copy the code into my original file, i ran into some error. i understand that the code contains a lot of .select and was advised to rewrite the code. can anyone help me with that? Sub Macro2()'' Macro2 Macro '...

Hi Why the code below is acceptable? Workbooks.Add.SaveAs Filename:="c:\testing.xlsx" The part I do not understand, is that Add is a method so why excel accept Add.SaveAs? The above code, means Add is an object. So I checked Add and it is method that return Workbook as a type. A function...

What is the Teradata connection string when connecting in VBA code? I understand that the provider now includes the version number.

Hi, I encountered the following oddity with Data Validation List behaviour and don't understand what exactly the problem is (Excel 2013 being used). I defined two ranges, MyList1 and MyList2. MyList1 captures the numbers 1-10 in cells a1:a10 MyList2 captures the same range + a blank cell in...

Hello all, I am trying to figure out what XIRR tells me exactly, I understand that it is a method used to calculate returns for a project, but in terms of what it actually means I am finding conflicting information from research online. Specifically I want to understand the difference between...

hi all here the sample: https://drive.google.com/open?id=1K8XzfwXLt79yqeQS2u6YJYw9E_g44w1M the row 8 have the TOTAL sums of each column, and in the row 9 add the minutes to hours. i captured manually the D column, but how to calculate? not understand, any help? Thanks

Hi, I have the following formula I am trying to understand =IF(IF(ROWS($EC$16:EC16)>$EO$14,"",INDEX($DU$16:$DU$512,MATCH(ROWS($EC$16:EC16),$EO$16:$EO$512,0)))=0,"",IF(ROWS($EC$16:EC16)>$EO$14,"",INDEX($DU$16:$DU$512,MATCH(ROWS($EC$16:EC16),$EO$16:$EO$512,0)))) the $DU$16:$DU$512 part is what...

Hello So im new to VBA, and for one of my WB's i want to sum a certain column up ( Column until a certain row which depends on a range on a different sheet. For example. If i have payments from day 1 to day 20 in column "B" on sheet "1340 $" and on my "Summary" Sheet i have the...

Hello all, i have a small xlsb file- 1.3 Mb that works just fine until i try to save it- then it blocks for about 5 minutes and i dont understand why. Can u help me with some advices? Thank you!

Hello I'm running Excel 2019 and I very recently added a pivot table/chart to my workbook, which has 15 other sheets. I've been making good use of Custom Views and although I read that Custom Views won't work if there's a table in the sheet, every sheet in my workbook already contains tables...

Hi The code below is to clear the whole sheet except the first row. Rows("2:"& Rows.Count).ClearContents I am unable to understand it. I would appreciate it if you can break it down so I can understand the logic behind it. Thank you so much

Hi I understand to find the last empty row, I can use this line of code x = Cells(Rows.Count, 1).End(xlUp).Row but now I just read an article and the following line is used to find the last row x = WorksheetFunction.CountA(Range("A:A")) + 1 I do not understand how the line above can find...

Good Morning, As I understand it, you cannot lock/unlock a VBA project with a module. Maybe someone can correct me on this. Here's what I'm trying to do. I have a hidden sheet that can only be unhidden with a password- I'd like a code (if it can be done) that hides the coding or makes it...

Hi I understand the code below what what I do not really understand is End(xlUp). I read that it is a Property of Range and it is of type of Range itself. It is used to change the direction of a cell. But what I do not understand, why xlUp passed between 2 () to me that suggest it is a...

I have a file of about 2500 companies, however, the addresses are very badly formatted. There are no real defined column names such as address line 1, city state zip. In many cases the data is spread over many columns and if some cases repeated. I would like to create an output where these...