128 reputation
5
bio website facebook.com/ourmaninbananas
location London, United Kingdom
age 46
visits member for 1 year, 4 months
seen yesterday

I am a developer at a retail bank in London, UK.

I mainly work in SQL Server and VB.NET, but love using Excel and Excel VBA


Sep
16
comment folder only search with Windows Search in Windows Server 2008
@TECHIE007: good point, they may not be indexed - I guess we'll have to manage with an alternative option like building a batch file or vba tool to list the folders and move them to a place where they will be off the network file server and on backup...
Sep
16
asked folder only search with Windows Search in Windows Server 2008
Jul
9
awarded  Teacher
Jul
9
awarded  Excavator
Jul
9
awarded  Editor
Jul
9
revised How can I speed up my macro in Excel 2003?
described the links
Jul
9
comment How can I speed up my macro in Excel 2003?
maybe even worth copying the sheet data to an array then working on it in memory
Jul
9
comment How can I speed up my macro in Excel 2003?
have you considered copying the sheet data to an array and working on it in memory?
Jul
9
comment How can I speed up my macro in Excel 2003?
in a addition to the useful and informative answers below, are you selecting cells or ranges explicitly within your loop? This is a big performance no no NO, try just using the Range object with variables...
Jul
9
suggested suggested edit on How can I speed up my macro in Excel 2003?
Jul
9
answered Writing VBA code to fill down to the end of a range which varies in length
Jul
1
comment How to import this data set into excel? (column headings on each row delimited by a colon)
why not open it from the text file, then use Copy> PasteSpecial - Transpose to transpose the data
Jul
1
comment Table of contents formatting
not really, in the end I had a document that was 250MB, so I started a new one, and copied everything over... thanks anyway
Jun
25
awarded  Supporter
May
20
asked Table of contents formatting
May
20
awarded  Autobiographer