understand

Hi I understand Columns/rows for example are property of range and their type is Range. I understand how to use them. But why we have Row/Column as Long? for what they can be used when I can not use Columns/Rows? Thank you.

I have inherited a spreadsheet with a formula I cannot quite figure out. =ROUND(TREND(F3:H3,$F$1:$H$1,4,1),-1) I understand everything except the 1 that follows the 4. What is that 1 mean? TIA

Hi I read under worksheet object, cells is defined as the following Property Cells As Range Ok what I understand from the above statement is that Cells is an object of type Range, in another word Cells=Range. But what I do not understand, what does "property" mean here? Also what "s" in...

Hi I want to make sure column A1:A10 user can only enter text. So with your help, thank you, now I understand I need to create custom data validation and the fomula is istext(A1) How to understand this? It is working but lets say I enter a text A1=hello then istext(A1) will return TRUE which...

Hi I am reading the article below and although he gave an example why converting number to text is needed, I did not understand the example. Can you please give me examples/reasons why that is needed? Thank you https://exceljet.net/formula/convert-numbers-to-text

Hi. Cell C3 contains “Not Specified, Not Specified, NotSpecified” however this is not always the case, it may contain a mixture oftext, symbols and numbers (i.e. there won’t always be 14 characters betweencommas) Cells C21, C22 and C23 contain a formula to split C3 intothree separate values C21...

I have crossposted a similar question at https://www.excelforum.com/excel-programming-vba-macros/1245764-using-vlookup-to-directly-lookup-values-instead-of-looping-through-combobox.html. I am trying to learn how to loop through a named range and a range and then using Application.Vlookup...

Hi all, I'm trying to return a row number of a specific string value, based off of the results of a range.find formula. I don't understand why, but the function is returning an integer and not a long data type. I have triple checked my variables, and "filelastrow" as well as "UCRMainLastRow"...

I am trying to learn more about arrays and I am trying to set an array to a range of cells (B5:M12). I am getting an error in the following code. Sub Macro3()Dim myArray() As Range, x, y As Integer For x = 2 To 13 For y = 5 To 12 Set myArray(x, y) = Range(Cells(y, x)) Next y...

Hi hope everyone is well. I have a if formula which i am assuming gets the start date from the given data , but i do not quite understand the logic and how it is doing the, the formula is below ="01"&"/"&IF(MONTH(A2)<10,"0"&MONTH(A2),MONTH(A2))&"/"&YEAR(A2) A2=29/11/2015 the formula...

If I add a calculated column to a table with PowerPivot, and the table in PowerPivot is linked to its counterpart in an Excel worksheet, how can I show the PowerPivot-calculated columns in the table in the Excel worksheet? I understand that Power Query has the capability to do this, but I do not...

Dear all, I'm trying to auto-populate a grid-like seating plan from a list of names. An example of the sequence is as followed: <tbody> name 1 name 5 name 9 name 13 name 2 name 6 name 10 name 14 name 3 name 7 name 11 name 15 name 4 name 8 name 12 name 16 </tbody> I've figured out how...

Hi I followed a video on how to put a pic in a UserForm. A combobox has (dog,cat, car) as a list and if user select cat, a pic of cat will appear in the from. I did exactly and it is working. But the code I did not understand is this Private Sub ComboBox1_Change() Image1.Picture =...

Hi I have a form to enter First and Last name and when I click on Enter to enter them, excel will put these 2 names in the last empty row. To grantee the last empty row, there are 2 ways (code). Thanks for your help I got to know them but could not understand them!. The first one x =...

Hi I want to create a table like the one below then fill it with random number and then draw a chart. All in VBA. Is the possible? I just want to learn this using VBA. I did it manually and then recorded the macro but it is too big to understand. Can the code be simple just to understand the...

Hello, I have a formula I inherited and I want to use actual cells to populate this. I don't know statistics enough to know what this says but can get kick started is anyone knows the math? In cell E3 the value is 6419 (the amount of samples I sent out) in F3 where the formula is the value is...

Hey guys, im very new to excel and its mind blowing me right now loll. I could use some serious help lol, unfortunately i dont understand what my partner has already done. I am happy ot teamviewer please just msg me in private and ill explain what i need via discord, whatsapp or in a text box...

I understand why I am receiving the error, is there a way to do error handling for the below code when "A3" is blank and "I3" = "YES" =IF(OR(C3="",C3="WG"),IF(AND(I3="YES"),"",""), IF(OR(C3="GE"),IF(AND(I3="YES"),(F3/A3),""), IF(OR(C3="H",C3="SR"),IF(AND(I3="YES"),(F3/1.05/A3),"")...

I have drawn a chart in excel using tabled values and these values of course were the coordinates by which the graph was drawn. But each certain series on points represent a certain thing called "ρ" (Refer to the attached picture to understand). Then i want to enter the graph with certain...

Wondering if you could tell me something about this formulabeing used. I understand what the formula is doing and how it worksbut what I don’t know is “why”? Why are they using-1? What does that even mean? When you usethe -1 you get a total different result so I’m trying to understand...