Click here to Skip to main content
14,488,452 members

Welcome to the Lounge


For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
GeneralRe: Over 6,000 pages, but all you needed (1998) Pin
Peter Shaw20-Feb-20 4:00
professionalPeter Shaw20-Feb-20 4:00 
GeneralSummer Sport Pin
W Balboos, GHB18-Feb-20 7:44
mveW Balboos, GHB18-Feb-20 7:44 
GeneralRe: Summer Sport Pin
dandy7218-Feb-20 8:03
Memberdandy7218-Feb-20 8:03 
GeneralRe: Summer Sport Pin
W Balboos, GHB19-Feb-20 2:05
mveW Balboos, GHB19-Feb-20 2:05 
GeneralRe: Summer Sport Pin
Richard MacCutchan18-Feb-20 10:34
mveRichard MacCutchan18-Feb-20 10:34 
GeneralRe: Summer Sport Pin
W Balboos, GHB19-Feb-20 2:09
mveW Balboos, GHB19-Feb-20 2:09 
GeneralRIP Andrew Weatherall (Musician/DJ) Pin
Maximilien18-Feb-20 7:34
MemberMaximilien18-Feb-20 7:34 
GeneralVBA in Excel PinPopular
Chris Maunder18-Feb-20 6:06
cofounderChris Maunder18-Feb-20 6:06 
I decided that, instead of manually categorising a bunch of values in a spreadsheet I'd write a simple VBA method that would do the hard work for me. After all, doing it manually would take about an hour. Writing a bit of VBA couldn't take more than... well, I think I'm on hour 5 at this point.

It's been a long time since I've done VBScript, but even VBScript was generally fairly sensible.

VBA? I can't believe it's 2020 and VBA is pretty much the only scripting option available in Excel. Sure, you can write add-ins using Javascript and in-cell formula using Javscript, but no Javascript scripting.

No constructor, serious hassles passing user defined types between methods, a limit to the number of times you can use line continuation in a row, the awful experience overall.

I can't believe how much of the world lives and breathes this stuff.

(but of course I'm going to bash my way through it instead of just getting the job done the old fashioned way)
Chris Maunder

GeneralRe: VBA in Excel Pin
CHill6018-Feb-20 6:15
mveCHill6018-Feb-20 6:15 
GeneralRe: VBA in Excel Pin
OriginalGriff18-Feb-20 6:16
mveOriginalGriff18-Feb-20 6:16 
GeneralRe: VBA in Excel PinPopular
Richard Deeming18-Feb-20 6:58
mveRichard Deeming18-Feb-20 6:58 
GeneralRe: VBA in Excel Pin
Chris Maunder18-Feb-20 7:35
cofounderChris Maunder18-Feb-20 7:35 
GeneralRe: VBA in Excel Pin
Richard Deeming18-Feb-20 7:44
mveRichard Deeming18-Feb-20 7:44 
GeneralRe: VBA in Excel Pin
Mark_Wallace18-Feb-20 12:14
MemberMark_Wallace18-Feb-20 12:14 
GeneralRe: VBA in Excel Pin
Mike Hankey18-Feb-20 8:51
professionalMike Hankey18-Feb-20 8:51 
GeneralRe: VBA in Excel Pin
Jörgen Andersson18-Feb-20 18:45
professionalJörgen Andersson18-Feb-20 18:45 
GeneralRe: VBA in Excel Pin
JurgenP318-Feb-20 21:52
MemberJurgenP318-Feb-20 21:52 
GeneralRe: VBA in Excel Pin
Chris Maunder19-Feb-20 3:13
cofounderChris Maunder19-Feb-20 3:13 
GeneralRe: VBA in Excel Pin
DJ van Wyk18-Feb-20 22:24
professionalDJ van Wyk18-Feb-20 22:24 
GeneralRe: VBA in Excel Pin
Member 1219748918-Feb-20 22:50
MemberMember 1219748918-Feb-20 22:50 
GeneralRe: VBA in Excel Pin
Member 1236439018-Feb-20 23:55
MemberMember 1236439018-Feb-20 23:55 
GeneralRe: VBA in Excel Pin
thewazz19-Feb-20 2:53
professionalthewazz19-Feb-20 2:53 
GeneralRe: VBA in Excel Pin
ZevSpitz18-Feb-20 23:22
professionalZevSpitz18-Feb-20 23:22 
GeneralRe: VBA in Excel Pin
Kirk 1038982119-Feb-20 3:45
MemberKirk 1038982119-Feb-20 3:45 
GeneralRe: VBA in Excel Pin
Peter R. Fletcher19-Feb-20 4:49
MemberPeter R. Fletcher19-Feb-20 4:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.