Thread
:
Way to store cell location to variable?
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Way to store cell location to variable?
close
a=1
b=2
Cells(a, b).value = ActiveCell
----------------
--
Don Guillett
SalesAid Software
"farful" wrote in
message ...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett