But that will do. Regardless, I updated the answer with a formula to extend it to work with two-letter columns.
I don't know why this answer got so many votes when Scot's answer is SO much better, except that he did not explain it. No complex formula needed. This works until you move to AA etc then its not going to work. To get column name I used the following formulae. Vikas Madaan. Can you add some explanation to this.
Here's a VBA, user defined formula, solution. Address 0, 0 , IIf rng. Here's how you can find the column heading i. The following formula works no matter where you put it it will give you back the column name. Please expand this answer by explaining what these functions are. Looking to understand which API is best for a certain task? A new study uses…. Featured on Meta. Feedback post: Moderator review and reinstatement processes. Post for clarifications on the updated pronouns FAQ. The last cell is only re-set when you save. It picks up cell fomatting. Let's say you enter any text or number in cell A10 and then enter a valid date in cell A20 of a new Worksheet.
Now delete the date in cell A20 and save.
This is because entering a date in A20 has caused Excel to automatically format the cell from " General " to a Date format. So when using VBA you cannot rely on:. Then choose an event from the " Procedure " drop down list box. Another approach which produces the same result is to use the Range object in conjunction with the Cells property, as shown here:. Row gives the row number of the current selection.
This address is then used as the parameter for the Range object, and the actual cell is selected by the Select method.
Excel Header Reference Cell
Note: If you would like to know how to use the macros described on this page or on any other page on the ExcelTips sites , I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip applies to Microsoft Excel 97, , , and You can find a version of this tip for the ribbon interface of Excel Excel and later here: Selecting a Cell in the Current Row. With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates , a computer and publishing services company.
Learn more about Allen If your company closes out its accounting months at the end of each calendar quarter, figuring out the proper closing Want to print your document only on odd-numbered pages in a printout? There are a couple of things you can try, as When you get rid of your Windows login password, you accomplish two things.
First, you make it easier to log onto your This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Want to use a worksheet function such as SUM from within a macro?
Active cell overview
Here's how easy it is to accomplish the task. Figuring out where Windows places certain items such as the user's desktop can be a bit frustrating.
Fortunately, there Do you want a way to reverse names within a cell, making them "last, first" instead of "first last? Enter your address and click "Subscribe. Your e-mail address is not shared with anyone, ever. Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced.
How to find duplicate values in Excel?
Up to three images may be included in a comment. All images are subject to review.
Commenting privileges may be curtailed if inappropriate images are posted. Thanks for the tips Allen.