View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Jan Karel Pieterse
 
Posts: n/a
Default Copy several cells with formulas as they are?

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.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com