Join 3,497 readers in helping fund MetaFilter (Hide)

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

Related tags:
+ (25)
+ (12)
+ (10)
+ (10)
+ (6)
+ (6)
+ (6)
+ (5)
+ (4)
+ (4)


Users that often use this tag:
jsturgill (2)
jozxyqk (2)
Mokusatsu (2)
johnstein (2)
Proginoskes (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