Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to set up a simple variable in Excel, but cell location independent | New Users to Excel | |||
how to set up a simple variable in Excel, but cell location independent | Excel Worksheet Functions | |||
Store cell data in a variable | Excel Programming | |||
VBA - Passing Cell Location To Variable | Excel Programming | |||
using variable as cell location | Excel Programming |