| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To return the column number of a string
Hello All,
I am pretty new to Excel Macros. I was writing a code and stuck up with this problem. I want to write the code to return the column number of a particular string. Like, I have "VET" string in one of the cells, A20 My code has to return to the column number 1 for the string "VET" Please help, Thanks, Prasanna. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
To return the column number of a string
Once you have established your string is in A20 then you return the column
number of the cell:- x = Range("A20").Column Mike " wrote: Hello All, I am pretty new to Excel Macros. I was writing a code and stuck up with this problem. I want to write the code to return the column number of a particular string. Like, I have "VET" string in one of the cells, A20 My code has to return to the column number 1 for the string "VET" Please help, Thanks, Prasanna. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To return the column number of a string | Excel Worksheet Functions | |||
| Look up values in a column and return ALL corresponding row number | New Users to Excel | |||
| In a column of numbers, how do I return the last non-zero number? | Excel Discussion (Misc queries) | |||
| Column() to return a letter instead of a number? | Excel Worksheet Functions | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
Linear Mode
