Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recording macro to paste a copied ws formula
Hello everyone,
Using the macrorecorder to record the pasting of a copied worksheetformula into a cell seems to cause a problem for a ws-formula that has, in this case, 252 characters. (Dutch MS-Office-Excel 2003/XP Home Dutch) Is there a way to have vba code insert such a long worksheetformula into a cell? For all intents and purposes I hereby give you the formula as is when the worksheet containing it is opened in the English version of MS-Office-Excel XP): =IF(ISERROR(IF(LEFT(id_projectie;4)="oud:";0;ROUND (SUM(D3:OFFSET(INDIRECT(E1 9);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2)));"";IF(LEFT(id_projectie;4)="oud: ";0;ROUND(SUM(D3:OFFSET(INDIRECT(E19);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2) )) The dutch words in this formula translate to: IF ALS ISERROR ISFOUT LEFT LINKS ROUND AFRONDEN OFFSET VERSCHUIVING Thanks for your help Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
recording macro to paste a copied ws formula
Hi Peter
I don't see your code but if you use activecell.Formula = ........................... Then use a , instead of ; in the VBA code (VBA = US) It will change it to ; when you open it in a Duch version -- Regards Ron de Bruin http://www.rondebruin.nl "Peter" wrote in message ... Hello everyone, Using the macrorecorder to record the pasting of a copied worksheetformula into a cell seems to cause a problem for a ws-formula that has, in this case, 252 characters. (Dutch MS-Office-Excel 2003/XP Home Dutch) Is there a way to have vba code insert such a long worksheetformula into a cell? For all intents and purposes I hereby give you the formula as is when the worksheet containing it is opened in the English version of MS-Office-Excel XP): =IF(ISERROR(IF(LEFT(id_projectie;4)="oud:";0;ROUND (SUM(D3:OFFSET(INDIRECT(E1 9);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2)));"";IF(LEFT(id_projectie;4)="oud: ";0;ROUND(SUM(D3:OFFSET(INDIRECT(E19);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2) )) The dutch words in this formula translate to: IF ALS ISERROR ISFOUT LEFT LINKS ROUND AFRONDEN OFFSET VERSCHUIVING Thanks for your help Peter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
recording macro to paste a copied ws formula
Hi Peter
After a private mail I understand your situation. Here is the problem http://support.microsoft.com/default...b;en-us;212172 -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Peter I don't see your code but if you use activecell.Formula = ........................... Then use a , instead of ; in the VBA code (VBA = US) It will change it to ; when you open it in a Duch version -- Regards Ron de Bruin http://www.rondebruin.nl "Peter" wrote in message ... Hello everyone, Using the macrorecorder to record the pasting of a copied worksheetformula into a cell seems to cause a problem for a ws-formula that has, in this case, 252 characters. (Dutch MS-Office-Excel 2003/XP Home Dutch) Is there a way to have vba code insert such a long worksheetformula into a cell? For all intents and purposes I hereby give you the formula as is when the worksheet containing it is opened in the English version of MS-Office-Excel XP): =IF(ISERROR(IF(LEFT(id_projectie;4)="oud:";0;ROUND (SUM(D3:OFFSET(INDIRECT(E1 9);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2)));"";IF(LEFT(id_projectie;4)="oud: ";0;ROUND(SUM(D3:OFFSET(INDIRECT(E19);0;-1))/MAX(E3:E14)*(12-MAX(E3:E14));2) )) The dutch words in this formula translate to: IF ALS ISERROR ISFOUT LEFT LINKS ROUND AFRONDEN OFFSET VERSCHUIVING Thanks for your help Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when I paste, instead of what I copied, I get an 'a'. | Excel Worksheet Functions | |||
Copied formula produces unexpected copied results | New Users to Excel | |||
Special Paste to Next empty row if new data and mark copied Macro | Excel Discussion (Misc queries) | |||
Recording time when a cell is copied in excel | Excel Discussion (Misc queries) | |||
Macro to paste a copied range | Excel Programming |