Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to insert a function within a sentence in Excel 200 | Excel Worksheet Functions | |||
function to insert a picture | Excel Worksheet Functions | |||
Is it possible to insert a macro command in an "IF" function? | Excel Worksheet Functions | |||
pethow do i insert a Yes/No function into a cell in Excel? | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |