Copy several cells with formulas as they are?
Jan Karel Pieterse wrote:
Hi Peter,
Another thing I noticed is that the macro only seems to copy multiple
formulas when they are listed below each other, i.e. in a column. When
I select formulas located next to each other, i.e. in a line, then
only the formula one column left to the first selected formula is
copied and inserted multiple times.
Could this have something to do with the fact that I use a German
version of Excel or are macro commands universal and
country-/language-independent?
Strange, I don't recall seeing these issues at all. In principle macro's
are US English, so version should make little difference. Sometimes it
does though.
Alright. I just changed the language scheme to "English (USA)" hoping
that this might make the macro work correctly but that didn't help
either.
Oddly enough, I don't get any error messages when using the macro.
Peter
|