VB Question - AutoFilter related - 'Criteria1:' secion of my code
Hi,
I have a simple bit of code to take me to another worksheet and
automatically select specific information falling under a autofilter.
Sample below:
Sheets("Sheet2").Select
Selection.AutoFilter Field:=1, Criteria1:="RandomText"
Range("A1").Select
This works great but it would be even better if I could refer to a
cell within the spreadsheet. How do I go about changing the criteria
to be a cell reference?
Since I have multiple sheets, do I need to specify the sheet name that
I'm calling the cell reference from?
Many, many thanks if you can help with this.
|