Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: combining data??

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Puerto Vallarta, Mexico
    Posts
    869
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    range("a015").value= MM1

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

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Puerto Vallarta, Mexico
    Posts
    869
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Sydney/Brisbane , Australia
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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=?

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Puerto Vallarta, Mexico
    Posts
    869
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •