Thread: Macro to select a list of values greater than or equal to a value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DOOGIE DOOGIE is offline
external usenet poster
  
Posts: 23
Default Macro to select a list of values greater than or equal to a va
OK, I will give it a shot.

"Don Guillett" wrote:

record a macor while doing itclean it up and post your result for comments.

--
Don Guillett
SalesAid Software

"DOOGIE" wrote in message
...
OK, I understand the use of the autofilter. Where I am confused is how to
use
a macro to select those cells that the autofilter returns and copy them to
another location. Can you help me with that?

"Don Guillett" wrote:

Easiest is to use
datafilterautofiltercustom

--
Don Guillett
SalesAid Software

"DOOGIE" wrote in message
...
I am trying to write a macro that will search through a list of values
(this
list will vary in size) for all values greater than or equal to a
specific
value (say =100). I want to activate all the cells containing those
values
and copy them to another location. Can anyone help with this?




Reply With QuoteReply With Quote