== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Warning: Undefined array key "comment" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_match_all(): Passing null to parameter #2 ($subject) of type string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 164.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

Bernds Rappelkiste | Artikel mit Tag vba Skip to content

Inhalt einer Excel-Zelle ausgeben lassen

Ich bin, wie vermutlich der ein oder andere weiß, Bauingenieur. In der Funktion mache ich hier im Büro überweigend Tragwerksplanungen für allen möglichen (Un-)Sinn…und das Mittel der Wahl ist dabei dann doch oft Microsoft Excel, weil man einfach am schnellsten und mit größter Variabilität verschiedene Berechnungen machen und anpassen kann.

Nun macht es allerdings wenig Sinn, wenn der Prüfingenieur nur ein Ergebnis einer Berechnung hat, ohne die Zwischenwerte prüfen zu können. Ab Excel 2013 gibt es zwar die Funktion formeltext(), allerdings hat die den großen Nachteil, dass Zellbezüge nicht aufgelöst werden. In der Berechnungsformel steht also immer A3/D6/Z123/usw. statt dem Wert, der in der Bezugszelle enthalten ist. Bei uns in der Firma gibt es für so etwas schon seit Jahren ein Visual Basic Script, welches dieses Problem behebt.

Bevor das eigentliche Script kommt noch kurz ein Beispiel, wie das bei der Verwendung aussieht. Nachfolgend eine kleine Beispieltabelle mit den Zelleninhalten:

A B C
1 A = 23
2 B = 5
3 X = =VERKETTEN(formeltext(C3;C3);"=") =B1^B2

In der Ausgabe sieht das dann wiefolgt aus:

A B C
1 A = 23
2 B = 5
3 X = 23^5 = 6436343

Als nette Spielerein werden noch diverse Ersetzungen gemacht, z. B. ^2 zu ² oder * zu einem richtigen Multiplikator-Zeichen. cool

"Inhalt einer Excel-Zelle ausgeben lassen" vollständig lesen
== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Warning: Undefined array key "html_nugget" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/serendipity_event_textile.php on line 180.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Notice: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_textile/lib3/src/Netcarver/Textile/Parser.php on line 2181.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Warning: Undefined array key "ep_disable_markup_serendipity_event_imageselectorplus:34ba0343cf0d7f01a68354358af1be85" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_imageselectorplus/serendipity_event_imageselectorplus.php on line 594.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Warning: Undefined array key "ep_disable_markup_serendipity_event_imageselectorplus:34ba0343cf0d7f01a68354358af1be85" in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_imageselectorplus/serendipity_event_imageselectorplus.php on line 594.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Warning: Cannot modify header information - headers already sent by (output started at /var/www/virtual/bauigel/bernd.distler.ws/include/compat.inc.php:207) in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_freetag/serendipity_event_freetag.php on line 812.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.

== ERROR-REPORT (BETA/ALPHA-BUILDS) ==

Warning: Undefined variable $headcss in /var/www/virtual/bauigel/bernd.distler.ws/plugins/serendipity_event_lightbox/serendipity_event_lightbox.php on line 226.
For more details set $serendipity['production'] = 'debug' in serendipity_config_local.inc.php to receive a stack-trace.