column name

Hi, I'm using variable for row and column in 2 different lines of code. But only the row varaible works; the column variable doesn't and I can't figure out why. partNum = Range("$B" & comRow).Text comCat = Range(comCol & "$5").Text Both variable are dimmed as integers. I thought there might be...

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...

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...

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...

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...

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

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...