combining data??

elgringo56 · May 8th, 2002, 06:34 PM

My problem is this. I have an alpha numeric value of onknown characters, lets say at this time its MM1. This value resides in a cell, lets say AS15. I need to append to this value, using a macro, the characters '= to end up with the expression '=MM1 in cell AO16. I cant seem to figguer out how to do this.

Qroozn · May 8th, 2002, 06:39 PM

range("a015").value= MM1

does this do the trick...(put it in your macro)

elgringo56 · May 8th, 2002, 06:53 PM

No, in fact, this did nothing at all. I need to append an '= to whatever resides in cell AS15.

Qroozn · May 8th, 2002, 07:04 PM

ok.. I'm a bit lost here.
you have cells as15, and ao15, and a defined value in a macro of MM1?

now what does..
"as15"=?
"ao15"=
mm1=?

elgringo56 · May 8th, 2002, 07:12 PM

OK, Cell AS15 contains an alpha numeric pattern, MM1 is the example I used but could be anything. What ever it is, I want to use it to filter a list with so I have to get it into a criteria range. But, using a value like MM1 as criteria to filter on will return all values that contain MM1 such as MM10 or MM12. To stop this the criteria needs to be '=MM1. Or, the value that is in AS15 preceded by the characters '=. I dont know how to get these characters onto the MM1 and into Cell AO15. All this must be within a macro which also contains the filter instruction. An operator is going to enter the value, in this case MM1.

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

May 8th, 2002, 06:34 PM	#1
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	My problem is this. I have an alpha numeric value of onknown characters, lets say at this time its MM1. This value resides in a cell, lets say AS15. I need to append to this value, using a macro, the characters '= to end up with the expression '=MM1 in cell AO16. I cant seem to figguer out how to do this.

May 8th, 2002, 06:39 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	range("a015").value= MM1 does this do the trick...(put it in your macro)

May 8th, 2002, 06:53 PM	#3
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	No, in fact, this did nothing at all. I need to append an '= to whatever resides in cell AS15.

May 8th, 2002, 07:04 PM	#4
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	ok.. I'm a bit lost here. you have cells as15, and ao15, and a defined value in a macro of MM1? now what does.. "as15"=? "ao15"= mm1=?

May 8th, 2002, 07:12 PM	#5
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	OK, Cell AS15 contains an alpha numeric pattern, MM1 is the example I used but could be anything. What ever it is, I want to use it to filter a list with so I have to get it into a criteria range. But, using a value like MM1 as criteria to filter on will return all values that contain MM1 such as MM10 or MM12. To stop this the criteria needs to be '=MM1. Or, the value that is in AS15 preceded by the characters '=. I dont know how to get these characters onto the MM1 and into Cell AO15. All this must be within a macro which also contains the filter instruction. An operator is going to enter the value, in this case MM1.