Stack Overflow
Stack Overflow

Questions tagged [structured-references]

Structure references define rectangular sections of tables using special syntax, table column names, and reserved keywords instead of relative or absolute references. Structure references do not need adjustment if tables they refer to have been modified. They also provide a mechanism to define areas using meaningful table column names instead of less helpful cell references. --source MSDN

23 questions
0
votes
0 answers

VBA updating R1C1 formula to table formula

I just started with a new company and checking their VBA codes and I noticed that they haven't been using table references and were using R1C1 references. Is there a way for Excel to update automatically so that the code changes all R1C1 references…
Wissam96
  • 11
  • 2
0
votes
1 answer

Excel Structured Reference - Retrieving current row with @ or #This Row is not working

I am on office 0365 enterprise version - Microsoft® Excel® for Microsoft 365 MSO (16.0.14228.20292) 32-bit. I am working on a table and would like to use structured referencing to dynamically retrieve the current selected row. I have gone through…
David Onyango
  • 77
  • 8
0
votes
0 answers

Structured table formula to separate text string after a hyphen

I am trying to find a oneliner VBA code that will use structured table reference to edit values in a column given as "United States of Amercia - USA". The aim is to delete everything before the hyphen (-) and only the "USA" part left. The code so…
Shoaib
  • 11
  • 1
0
votes
0 answers

Excel changes a formular I define with the Range.FormulaLocal into a Formula with structured references. I do not want that, how can I change it?

I want to insert a formula into a sequence of cells by using a "for-loop". My formula references other cells that change for each loop. The formula itself works but when I enter it with Range.FormulaLocal it changes and my references to other…
user13539707
0
votes
0 answers

Use the text of a cell as the argument of range() with structured references

I want to execute an advanced filter with vba. The problematic step is that the name of the source table (for the advanced filter) is written in a cell and it seems I can't find a way to pass it to range(). Here is the idea: The F5 cell contain…
Alexandre Rivara
  • 113
  • 1
  • 11
0
votes
2 answers

Conditional copying from a table in Excel

I'm trying to copy to both debit/credit columns to other tables which match only the respective account value i.e. all Cash entries go to a Cash Account table, etc. I'll also need a way to omit those that have already been copied (so some check…
Mark Slater
  • 141
  • 2
  • 9
0
votes
1 answer

How to reference a table ignoring the offset

Excel 2013: I have several single-column tables on a Lookup's sheet which are used to validate various columns around my workbook. I now need to add a mapping table to map all values from one of these tables (tbl_Validation) to text values on a…
Dead.Rabit
  • 1,965
  • 1
  • 28
  • 46
0
votes
1 answer

Excel table reference (structured) change to absolute range (A1) after re-opening

I have a Table named table2 on my sheet2, and I'm using its values on sheet1 with the help of structured references, like: =average(table2[values]) But after saving and re-opening the file, all my structured references are being converted to…
Gabriel L. Oliveira
  • 3,922
  • 6
  • 31
  • 40
1
2