Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Position
Hi,
I am trying to write down a macro. I am using the following one line code to find out where "volume" is written in a cell. Cells.Find("Volume").Activate I would like to know the cell number or position, wheather it is B12 or A12 or S12. Whatever may be the position. I want to track the position, and based on that position i need to copy some associated values. Any help or directions will be appreciated Thanks, Mazed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Position
you don't give a whole lot of info to streamline anything, but
celladdress = Cells.Find("Volume").address -- Gary "mazu" wrote in message ... Hi, I am trying to write down a macro. I am using the following one line code to find out where "volume" is written in a cell. Cells.Find("Volume").Activate I would like to know the cell number or position, wheather it is B12 or A12 or S12. Whatever may be the position. I want to track the position, and based on that position i need to copy some associated values. Any help or directions will be appreciated Thanks, Mazed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Position
Try something like
Dim c 'Search the active sheet for "Volume" Set c = Cells.Find(What:="Volume", After:=Range("A1"), LookIn:=xlValues) 'Returns Nothing if not found If Not c Is Nothing Then MsgBox c.Address End If Hope this helps, Hutch "mazu" wrote: Hi, I am trying to write down a macro. I am using the following one line code to find out where "volume" is written in a cell. Cells.Find("Volume").Activate I would like to know the cell number or position, wheather it is B12 or A12 or S12. Whatever may be the position. I want to track the position, and based on that position i need to copy some associated values. Any help or directions will be appreciated Thanks, Mazed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to get the first used cell position in VBA? | Excel Programming | |||
move within ss by active cell position, NOT by cell names | Excel Programming | |||
Position of CellCursor on Screen (absolute position) | Excel Programming | |||
cell position | Excel Programming | |||
Cell Position | Excel Programming |