2 posts tagged with excel by Mokusatsu.
Displaying 1 through 2 of 2.

Related tags:
+ (188)
+ (86)
+ (66)
+ (46)
+ (46)
+ (45)
+ (44)
+ (33)
+ (30)
+ (30)
+ (24)
+ (23)
+ (22)
+ (21)
+ (20)
+ (20)
+ (20)
+ (18)
+ (16)
+ (16)
+ (15)
+ (14)
+ (14)
+ (14)
+ (14)
+ (13)
+ (13)
+ (13)
+ (13)
+ (13)
+ (12)
+ (12)
+ (12)
+ (12)
+ (11)
+ (11)
+ (11)
+ (11)
+ (10)
+ (10)
+ (10)
+ (10)
+ (10)
+ (9)
+ (9)
+ (9)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (8)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)
+ (7)


Users that often use this tag:
TheBones (6)
malcommc (5)
zardoz (4)
willnot (4)
Anonymous (4)
FireStyle (4)
anastasiav (3)
goethean (3)
mwhybark (3)
Mr. Justice (3)
keep it tight (3)
apark (3)
GilloD (3)
foxinthesnow (3)
SirStan (3)
jefficator (3)
corpse (3)
desjardins (3)
undercoverhuwaaah (3)
jujube (3)
Jackie_Treehorn (3)
skypieces (3)
ttyn (3)
bluejayway (3)
Conrad Cornelius o... (3)
thankyoumuchly (2)
Flunkie (2)
freddymetz (2)
ewiar (2)
bleucube (2)
jestonb (2)
underwater (2)
slavlin (2)
johnstein (2)
beammeup4 (2)
pdb (2)
pantufla (2)
nevercalm (2)
rossination (2)
bigmusic (2)
elgilito (2)
wtfwjd? (2)
Bugbread (2)
digitalprimate (2)
Classic Diner (2)
sdis (2)
bibbit (2)
SheIsMighty (2)
Rock Steady (2)
WCityMike (2)
nickerbocker (2)
panoptican (2)
nooneyouknow (2)
furtive (2)
ObscureReferenceMan (2)
pwb503 (2)
Jimbob (2)
jessamyn (2)
dmd (2)
synecdoche (2)

Stumped by VBA-ising an array formula in Excel

How to do a VBA version of the following array formula in Excel? The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA: {="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)} [more inside]
posted by Mokusatsu on Oct 17, 2008 - 3 answers

 

Turning a complex Excel spreadsheet with VBA functions into an online app

I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA? [more inside]
posted by Mokusatsu on Sep 12, 2008 - 2 answers

Page: 1