Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find ActiveCell.column
When I use the Activecell.column statement it returns a numeric value for the
column(ex: 27), I want the character value (ex: AA). Here is a sample of my code, I always want to access row #1, but the column will vary based on the activecell location: Dim sColumn as string Dim sRangeName as string Dim sValue as string sColumn = activecell.column sRangeName = sColumn + "1" sValue = worksheets("sheet1").range(sRangeName).value |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set ActiveCell at the first column of the same row... | Excel Discussion (Misc queries) | |||
How To Find If The ActiveCell Is Protected | Excel Discussion (Misc queries) | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
Activecell.FormulaR1C1 Versus ActiveSheet.cells(column, row) | Excel Programming | |||
Use of Selection.Find & ActiveCell | Excel Programming |