column name

  1. B

    Dynamic Column Name Identifier Formula (USING MOST RECENT VERSION OF OFFICE 365)

    File: Dynamic Column Identifier Formula.xlsm I created this formula to dynamically return the column name based on the corresponding column number. That said, it works intermittently once you get to Column AA. I could understand if it was broken completely at Column AA and beyond, but I cannot...
  2. A

    Formulas to make references independent-multiple sheets

    I am gonna try to make the question simpler (so only one reference is required) the actual sheet has 54 reference columns. Sheet 1 Column A: Agent ID Column B: Agent Name Column C: Agent Region Column D: Member ID Column E: Member First Name.... Sheet 2 Column A: Member ID Up till now i...
  3. R

    structured reference: using column name in header row to identify column

    folks, not quite sure how to present this properly. so bear with with me: 1. i have userform, and would like to do a calc inside the userform, referencing a cell in the xls 2. the cell is in the same row as the 'active cell', but it is in a different column and also, 3. since the xls is in...
  4. A

    Trouble setting a column range to a name in VBA

    Hi all, I need to set a name to a range (Col T in sheet1) so I can use it in an Intersect statement. I am sure it is an easy fix but I can't see it. Extracts from my (latest attempt) code: Dim FailureGroupCodes As Range FailureGroupCodes = Sheets("Sheet1").Range("T:T") I have...
  5. G

    Row Number and column Name in Vba

    Hi All, how can we get row no and column name of spreadsheet object in VBa. i want to check vaule of first cell of the column with a variable. Let Activecell = H15 i want to check value of "H1" on command button click event. please help. thanks
  6. C

    Pivot table values: renamed vs. original

    How can I determine which (renamed) values in the pivot table correspond to which values in the source data table? A simplified example: In the source table, the field 'salesperson' has values 1, 2, 3. In the pivot table, those values were renamed long ago to 'John', 'Sally', 'Dave'. How...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top