Capture value in worksheet & use in macro code

  • Thread starter Robert E. Leonard Sr
  • Start date
R

Robert E. Leonard Sr

in macro have code:
01=Range("a3").value


cell a3 is in worksheet & can contain word "Product:" or a number like 4

what code can I use to use what is captured in 01 above in a line of macro
code such as:

selection,autofilter filter = (value of 01)

I am trying to run an autofilter from fields located in worksheet.
thanks
rleonard
 
B

Bob Phillips

selection.autofilter Field:=1, Criteria1:= 01

or maybe

selection.autofilter Field:=1, Criteria1:= """ & 01 & """

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display contents of cell in macro 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Filtering with marcos 2
.copy problems 4
Excel Macro to use cells as a autofilter 0
loop until empty row and column problem (format cells until the lastrow and column in a report) 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro to use information in a cell to locate and send files using outlook 0

Top