Excel Reference To Current Cell

by

Several years too late:

Just for completeness I want to give yet another answer:

First, go to Excel-Options -> Formulas and enable R1C1 references. Then use

  =CELL("width", RC)

RC always refers the current Row, current Column, i.e. “this cell”.

Rick Teachey’s solution is basically a tweak to make the same possible in A1 reference style (see also GSerg’s comment to Joey’s answer and note his comment to Patrick McDonald’s answer).

Cheers
🙂

More Related Contents:

  1. How to turn a string formula into a “real” formula?
  2. Last non-empty cell in a column
  3. Excel formula to get cell color [duplicate]
  4. Rounding in MS Access
  5. Fill non-contiguous blank cells with the value from the cell above the first blank
  6. How to extract text within a string of text
  7. Get parent folder path from file path using cell formula
  8. Excel VBA – How to add dynamic array formula
  9. Difference between date and time w/out work week Excel
  10. Combine 2 Excel tables into one appending the data?
  11. Compare double in VBA precision problem
  12. Row count on the Filtered data
  13. Excel VBA Macro: User Defined Type Not Defined
  14. Automate IE via Excel to fill in a dropdown and continue
  15. Run-Time error 1004 Excel 2013
  16. VBA – Write all possible combinations of 4 columns of data [duplicate]
  17. Remove duplicates from array using VBA
  18. Controlling Internet Explorer local intranet using Excel VBA
  19. How to automatically insert a blank row after a group of data
  20. Get File Path (ends with folder)
  21. Get length of array?
  22. Email a single attachment from folder of files each to a different person
  23. Bad data selection using VBScript , on date field values
  24. How to list all possible combinations of the values in three columns in excel?
  25. Sending object array to variant works before August 2019 Windows update, but fails after update
  26. Find last row in range
  27. Differences between Excel’s Form Controls & ActiveX Controls
  28. Excel VBA User Defined Function that counts cells with conditional formatting
  29. How to open a workbook specifying its path
  30. How to protect Excel workbook using VBA?

Leave a Comment