where/how to insert a function

[Guest]

I am trying to copy a macro with a function from www.rondebruin.nl/copy2.htm
site.
It has explained how to enter the MAcro but not mentioned how/where to
insert the function. how should I do this? sorry for simple question but it
is my first time use function command in excel.

 

[Ron de Bruin]

Hi

See my reply in one of your other threads

On my site you an read this

Where do I place the code and the functions?
1. Alt-F11
2. Insert>Module from the Menubar
3. Paste the Code there
4. Alt-Q to go back to Excel
5. Alt-F8 to run the subs

 

[Guest]

Hi Ron
It worked. Thanks a lot. I have a question.
You mentioned: sh.Columns("A:C").Copy
How it would be if want to copy non-adjacent columns like: Colums A,B,D,E,G?

 

[Guest]

Your solution puts columns next to each other. Is there a solution to add
columns to end of previous columns.
In other words, in master sheet, number of columns remain same but number of
raws increase?

 

[Guest]

You can try:
sh.Range("A:B,D:E,G:G").Copy

-Simon

 

[Guest]

It gives: RUN-time error 13, Type mismatch

 

[Guest]

I think I got the answer to my own question.
I think the consolidate command will do what I want. Add data to end of
previous raws