formula

elgringo56 · May 8th, 2002, 04:35 PM

OOPS, now I have a real problem. I am filtering for a value, MM1. But, I dont know really what that value is as it is being selected by another macro. I need to affix a ="= to the front of it and a " to the back of it so that it becomes ="=MM1". Any ideas?

Jay Petrulis · May 8th, 2002, 05:11 PM

Quote:

On 2002-05-08 15:35, elgringo56 wrote:
OOPS, now I have a real problem. I am filtering for a value, MM1. But, I dont know really what that value is as it is being selected by another macro. I need to affix a ="= to the front of it and a " to the back of it so that it becomes ="=MM1". Any ideas?

Let s = your value ("MM1" in this case)

YourRange.AutoFilter Field:=1, Criteria1:=s

should work.

Qroozn · May 8th, 2002, 05:12 PM

in the macro can you stipulate that range ("a1"). value = MM1

or something similar so then the worksheet will show you what the value is and hrence you know what to filter for?

elgringo56 · May 8th, 2002, 05:21 PM

Not sure of either answer. I am a pure novice, thru and thru. Ok, here is what I am doing. I am trying to filter, under macro control, for a certian row of info within a list. each row has a unique alpha numeric designation, such as MM1, but could be anything, AQ7, etc. If I filter for MM1, I am returned MM1, MM10, MM11....MM19, MM100, etc, same with any other alpha combo. I was told, and found it to be true that if I filter using the criteria '=MM1, it will only find, MM1. Now, I can put the filter criteria, MM1 into any know cell, but I then have to, under macro control, append the '= protion so I can then put that into the criteria range. I have no idea how to do this. Learning tiny bits every day, but havn't figgured this out yet. Any ideas?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 04:35 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	OOPS, now I have a real problem. I am filtering for a value, MM1. But, I dont know really what that value is as it is being selected by another macro. I need to affix a ="= to the front of it and a " to the back of it so that it becomes ="=MM1". Any ideas?

May 8th, 2002, 05:12 PM	#3
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	in the macro can you stipulate that range ("a1"). value = MM1 or something similar so then the worksheet will show you what the value is and hrence you know what to filter for?

May 8th, 2002, 05:21 PM	#4
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Not sure of either answer. I am a pure novice, thru and thru. Ok, here is what I am doing. I am trying to filter, under macro control, for a certian row of info within a list. each row has a unique alpha numeric designation, such as MM1, but could be anything, AQ7, etc. If I filter for MM1, I am returned MM1, MM10, MM11....MM19, MM100, etc, same with any other alpha combo. I was told, and found it to be true that if I filter using the criteria '=MM1, it will only find, MM1. Now, I can put the filter criteria, MM1 into any know cell, but I then have to, under macro control, append the '= protion so I can then put that into the criteria range. I have no idea how to do this. Learning tiny bits every day, but havn't figgured this out yet. Any ideas?