Thread
:
Runtime error 1004 when trying to insert formula in cells
View Single Post
#
4
Posted to microsoft.public.excel.programming
Claus Busch
external usenet poster
Posts: 3,872
Runtime error 1004 when trying to insert formula in cells
Hi Jan,
Am Sun, 5 Oct 2014 04:57:40 -0700 (PDT) schrieb
:
Claus - I have aldready tried that, but get the same runtime error.
I tested it here without any error.
Did you select some cells before running the macro?
Do you write a "=" in front of the formula into the InputBox?
Have you tried it with Formula.Local that you can use your function
names and your separators?
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch