Way to store cell location to variable?

I was wondering if there was a way to store a cell's location to variables.

Something like:

Please Login or Register  to view this content.

I'm currently working with a fairly large worksheet, and I'm using Cells.Find to look for a specific cell. Then I want to Filter that column, but I can't figure out what column Selection.AutoFilter Field:=?? should be.

Any suggestions?

Farful

Here are a few ways

Sub AssignToVariables()
Dim sAddress
Dim lRow As Long
Dim iColumn As Integer
With ActiveCell
sAddress = .Address
lRow = .Row
iColumn = .Column
End With
MsgBox "Active cell address is " & sAddress & Chr(13) & _
"Row is, " & lRow & ". Column is, " & iColumn & "." & Chr(13) & _
"Therefore I can also reference it: Cells(" & lRow & " , " & iColumn &
")"
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"farful" <[email protected]> wrote in
message news:[email protected]...
>
> I was wondering if there was a way to store a cell's location to
> variables.
>
> Something like:
>
> Code:
> --------------------
>
> int a, b
> Cell(a, b) = ActiveCell
> --------------------
>
>
> I'm currently working with a fairly large worksheet, and I'm using
> Cells.Find to look for a specific cell. Then I want to Filter that
> column, but I can't figure out what column Selection.AutoFilter
> Field:=?? should be.
>
> Any suggestions?
>
>
> --
> farful
> ------------------------------------------------------------------------
> farful's Profile:
> http://www.excelforum.com/member.php...o&userid=36172
> View this thread: http://www.excelforum.com/showthread...hreadid=560892
>

close
a=1
b=2
Cells(a, b).value = ActiveCell
----------------

--
Don Guillett
SalesAid Software
[email protected]
"farful" <[email protected]> wrote in
message news:[email protected]...
>
> I was wondering if there was a way to store a cell's location to
> variables.
>
> Something like:
>
> Code:
> --------------------
>
> int a, b
> Cell(a, b) = ActiveCell
> --------------------
>
>
> I'm currently working with a fairly large worksheet, and I'm using
> Cells.Find to look for a specific cell. Then I want to Filter that
> column, but I can't figure out what column Selection.AutoFilter
> Field:=?? should be.
>
> Any suggestions?
>
>
> --
> farful
> ------------------------------------------------------------------------
> farful's Profile:
> http://www.excelforum.com/member.php...o&userid=36172
> View this thread: http://www.excelforum.com/showthread...hreadid=560892
>