Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Grey Area: Sep 9, 2000; Battle Without Honor or Humanity

Is there a way to do sprintf() or String.format() in VBA (Excel 2003)? Using lots of & gets unreadable fast.

edit: Any idea why this gives a 1004 error:

code:

yearClassAvgPrice = "=IF(SUM(Totalt!$C$7:$C$23)=0;0;SUMPRODUCT(Totalt!$C$7:$C$23;Totalt!$D$7:$D$23)/SUM(Totalt!$C$7:$C$23))"
SummaryOrigin.Offset(7, 5).Value = yearClass1AvgPrice

Pasting the formula into a cell works.

Grey Area fucked around with this message at 07:41 on Jul 22, 2010

# ¿ Jul 22, 2010 07:13

Adbot: ADBOT LOVES YOU

# ¿ May 5, 2024 23:35

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread