|
where/how to insert a function
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. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan where/how to insert a function |
where/how to insert a function
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. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan where/how to insert a function |
where/how to insert a function
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? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: 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. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan where/how to insert a function |
where/how to insert a function
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? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: 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. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan where/how to insert a function |
where/how to insert a function
You can try:
sh.Range("A:B,D:E,G:G").Copy -Simon "Khoshravan" wrote: 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? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: 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. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan where/how to insert a function |
where/how to insert a function
It gives: RUN-time error 13, Type mismatch
-- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "SimonCC" wrote: You can try: sh.Range("A:B,D:E,G:G").Copy -Simon "Khoshravan" wrote: 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? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: 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. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan where/how to insert a function |
where/how to insert a function
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 -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Khoshravan" wrote: 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? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "Ron de Bruin" wrote: 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. InsertModule from the Menubar 3. Paste the Code there 4. Alt-Q to go back to Excel 5. Alt-F8 to run the subs -- Regards Ron de Bruin http://www.rondebruin.nl "Khoshravan" wrote in message ... 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. -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan where/how to insert a function |
| All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com