VBA - Passing Cell Location To Variable

Group,
Lets assume I'm working in a spreadsheet that changes weekly. There are numerous calculations, and a cell is selected. How do I pass the cells location, for example B7 into a variable? This week the location can be B7, but next week it could be B9. I don't know the location after I run the macro presently. That is why I want to pass it to a variable for later use. Its probably very simple, but for a novice its pretty tough. TIA.

Tony

see if maybe creating a dynamic range will help you

http://www.contextures.com/xlNames01.html

--


Gary


"ajocius" <[email protected]> wrote in
message news:[email protected]...
>
> Group,
> Lets assume I'm working in a spreadsheet that changes weekly.
> There are numerous calculations, and a cell is selected. How do I
> pass the cells location, for example B7 into a variable? This week the
> location can be B7, but next week it could be B9. I don't know the
> location after I run the macro presently. That is why I want to pass
> it to a variable for later use. Its probably very simple, but for a
> novice its pretty tough. TIA.
>
> Tony
>
>
> --
> ajocius
> ------------------------------------------------------------------------
> ajocius's Profile:
> http://www.excelforum.com/member.php...o&userid=17695
> View this thread: http://www.excelforum.com/showthread...hreadid=472859
>

Not what I'm looking for. Assume my active cell is someplace(location unknown). But at some point in my macro I need to put its location into a variable for use later in the macro. How do I pass that location to the variable?

Tony