rlr@toccata.rutgers.edu (Rich Rosen) (09/26/90)
I am posting this article for a friend of mine without net access. Please send any and all responses to him at the "Reply-To:" address. (dcdwest!vaxf!smh@ucsd.edu) Thanx in advance. The question is: how can you concatenate the text string contents of two different cells into a third cell using a macro? My friend has been able to perform the operation manually using the mouse to grab and select blocks of text and piece them together cut-and-paste fashion, but he cannot figure out how this could be included in an Excel macro. When he runs the recorder to try and capture this set of actions, the actions take place, but the recorder seems oblivious to this and does not record any of the select-cut-and-paste actions into the macro. Searching Excel manuals/books for commands or other methods for doing this has been fruitless. Any ideas? -- "While Mona Lisas and mad hatters, sons of bankers, sons of lawyers, turn around and say 'good morning' to the night, for unless they see the sky, but they can't and that is why they know not if it's dark outside or light." Rich Rosen rlr@toccata.rutgers.edu
ramaley@csli.Stanford.EDU (Alan Ramaley) (02/02/91)
Excel, in a macro, always follows a reference. so if cell c2 in a macro sheet has a reference, say, 'partition'!$c3, or something along those lines, doing a select(c2) won't select cell c3 on partition, but instead will follow the reference, and try to select the region described by cell c3. Normally this is a good thing; but how do you stop this dereferencing? Otherwise, "input(8)" which returns a reference, is useless, if you want to do an operation on the cells selected. -- --Alan