View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
farful[_3_] farful[_3_] is offline
external usenet poster
 
Posts: 1
Default Way to store cell location to variable?


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

Something like:

Code
-------------------

int a, b
Cell(a, b) = ActiveCel
-------------------


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

Any suggestions

--
farfu
-----------------------------------------------------------------------
farful's Profile: http://www.excelforum.com/member.php...fo&userid=3617
View this thread: http://www.excelforum.com/showthread.php?threadid=56089