referring

Dear Excel community Is there a way to source the input for a certain formula from other cell values? For example: cell A1 = "tab1"; cell A2 = A1; and cell A3 = Q1. Instead of writing =sum('tab1'!A1:Q1), I am looking for a way to express the same formula referring to the values/text in cells...

im trying to insert a table in a specific range (b10 to bb11)....when I try to add to the table by typing something in b12, the referernces are messed up...eg W12 should be referring to b12, but instead references b13. yes, i removed the header row and Excel did make a warning about formulas...

ActiveWorkbook.Worksheets("Sheet2").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("Sheet2").AutoFilter.Sort.SortFields.Add Key:=Range _ ("AB1:AB97515"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With...

I had a VBA debugging problem that i finally solved with difficulty. Along the way, i wanted to find out what workbook a Range object was referring to, but it seems that Range does not have a Workbook property. So, i wanted to verify that, and ask if there is any way i could have gotten at the...

In my workbook, the names of some of the worksheets sometimes change. However, the sheet "numbers" never change. I need to assign the name of a particular sheet to a variable, so I can refer to the name later on in code. I figured out how to do it, using this: Dim NameOfSheet As String...

Please consider this following simple code: Private Sub uf1cbx1_operatorini_Change() 'populate uf1lbl1_name uf1lbl1_name = Application.WorksheetFunction.VLookup(uf1cbx1_operatorini.Value, ufrng1_staff, 2, False) End Sub When the user changes the value in the combobox...

Hi I've been given a spreadsheet to work through and there's a formula that I've never seen before. It's =IF(SUM(COUNTIF(E3,{"*M*","*T*","*W*","*F*"})),"O","") The curly brackets are there whether Ctrl Shift and Enter is used or not. The only time I've seen curly brackets are for arrays...

Hello, Is it okay to refer to another forum to get some help? Thank you

Is it possible to UNDELETE object like TextBox1 since I have other codes referring this object and do not want to add a new one !?:confused: Thanks.

If I have column A and B and I have an IF formula with 64 nested conditions on A2, referring to the exact value (alphanumeric) of A1, how can I have this formula on B2 referring to B1 without changing every reference manually? I can just do find and replace on any text editor, but I need this to...

https://www.screencast.com/t/xO9c1xi7M9D Is there any way to stop this from popping up while I am running my code? The Immediate window is empty and there are no lines of code referring to Debug.Print. Using Excel 365 and Windows 10 64 bit. Any help would be greatly appreciated.