Hello everyone,
I am looking to build a simple macro performs a text to column function. See below:
It works well enough but I want to be able to highlight any range I want and then use the macro. For example with a paste special macro I can just use "Selection.Copy" and that macro will perform the function on any range that I highlight. How can I do the same with the macro above?HTML Code:
Thanks
Eddie
Last edited by punter; 08-25-2014 at 04:26 PM.
Will the destination change based on what you have highlighted?
It seems like the solution you posted fits your problem.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Thank you for the reply.
Wouldn't I need to change something with the destination range?
I am not sure what solution I posted that you are referring to. It might be right in front of me and I'm not seeing it.
Thank you so much for your help. I look forward to your response.
Eddie
Eddie
Where would you want the results to go?
Also, will all the parameters/settings, eg delimiters etc, be the same every time?
If posting code please use code tags, see here.
I would want the results to stay in the same column as the data. I am just looking to eliminate everything after the "#".
I was thinking more about row than column.
In the example you posted, if you wanted the results to end up to end up in the first row of the selection you could use Selection.Cells(1,1) for Destination.
That worked great. Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks