Inserting text from a cell into VBA code

• • Reply

  11 years ago

  by ymohammad

  Yusuf Mohammad

  London, United Kingdom

  Joined 11 years ago

  I have a macro that amongst other things sorts a number of lists by a month, however instead of rewriting the code for every month i want to be able to enter the month into a cell and have the code pick up that month and sort by it. How can I do this?

  For example, my autofilter is: Selection.CurrentRegion.AutoFilter Field:=4, Criteria1:="Jul09"

  But I want to replace the Jul09 with a link to a cell in which i can enter any date in the form "mmmyy" and have the code filter by that date.

  Thanks!

  Report abuse
• • Reply

  11 years ago

  by Uncle

  Uncle

  England, United Kingdom

  Joined 19 years ago

  If your month is in cell F1, you can use code like this:

  Selection.CurrentRegion.AutoFilter Field:=4, Criteria1:=Range("F1").Value

  to select the cell value as the criteria.

  Report abuse
• • Reply

  11 years ago

  by ymohammad

  Yusuf Mohammad

  London, United Kingdom

  Joined 11 years ago

  Excellent, thanks!

  Report abuse