+ Reply to Thread
Results 1 to 13 of 13

Thanks Romperstomper

  1. 10-15-2010, 05:48 AM #1
    Andrew-R
    Andrew-R is offline
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Thanks Romperstomper

    I haven't been on the forum much this week (work's very busy), but I wanted to pop in to thank RS for recommending the Professional Excel Developer's guide. My copy arrived on Wednesday and though I haven't had much time to spend on it yet (I'm about 60-odd pages in) it's just absolutely brilliant.

    Until I joined this forum I thought I knew pretty much everything there was to know about VBA, a couple of months in I was realising that I still had a bit to learn, now I've got this book and I realise I haven't even scratched the surface.

    Ignorance rocks
    Reply With QuoteRegister To Reply
  2. 10-15-2010, 06:26 AM #2
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,303

    Re: Thanks Romperstomper

    You're welcome.
    It's always fun to discover a whole new level of things in your favourite program, isn't it?
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  3. 10-15-2010, 06:38 AM #3
    Andrew-R
    Andrew-R is offline
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Thanks Romperstomper

    Oh yes.

    Until last night I didn't realise you could declare a variant and then set it to a range and have Excel magically turn it into a two dimensional array of values. How useful is that!

    I'm coding this morning (for work) and my code looks a *lot* different to anything I've previously done...

    Please Login or Register  to view this content.

    Neat.
    Reply With QuoteRegister To Reply
  4. 10-15-2010, 06:46 AM #4
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,303

    Re: Thanks Romperstomper

    Quote Originally Posted by Andrew-R View Post
    Until last night I didn't realise you could declare a variant and then set it to a range and have Excel magically turn it into a two dimensional array of values. How useful is that!
    Yep. The thing that sometimes catches people is that it's always a 2D array (assuming more than one cell!), even if you only refer to one row or column.

    Nice looking code, too.
    Reply With QuoteRegister To Reply
  5. 10-15-2010, 07:38 AM #5
    Domski
    Domski is offline
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Thanks Romperstomper

    Quote Originally Posted by Andrew-R View Post
    Until last night I didn't realise you could declare a variant and then set it to a range and have Excel magically turn it into a two dimensional array of values. How useful is that!
    I'm sure I should use arrays a lot more than I do in my code. Not something I've ever really got into the habit of doing.

    I also know I should buy PED and actually spend some time learning from it rather than just adding it to my growing pile of Excel books that sit on my desk gathering dust.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
    Reply With QuoteRegister To Reply
  6. 10-15-2010, 08:12 AM #6
    Andrew-R
    Andrew-R is offline
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Thanks Romperstomper

    It's actually my first Excel book (not counting the manuals that used to come packed with MS Office), I don't even have many technical books at all. Looking at my bookshelves the other night showed such classics as Dummy's guide to XML (mainly unread, because my desire to understand XML proved to be lower than my willingness to tolerate the word 'Wellformedness') and The complete developer's guide to Windows '95, although I was surprised to find my battered copy of The Acorn Electron user's guide and a well-thumbed BBC Micro Advanced User's Guide were still lurking in there.

    On the other hand, if anybody's got any questions about midwifery* there are dozens of books on that subject littering my bookshelves**

    * US translation = witchcraft
    ** Because it's my wife's job, it's not just a perversion I have.
    Reply With QuoteRegister To Reply
  7. 10-15-2010, 09:05 AM #7
    Domski
    Domski is offline
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Thanks Romperstomper

    I'm pretty sure I've still got manuals for the BBC Micro and Commodore 64 lying around somewhere. I think they both came with fold out circuit diagrams which I obviously found incredibly useful.

    Dom
    Reply With QuoteRegister To Reply
  8. 10-15-2010, 09:12 AM #8
    Andrew-R
    Andrew-R is offline
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Thanks Romperstomper

    The BBC advanced user's guide does, indeed, have a fold out circuit diagram included, but it wasn't in the standard guide.
    Reply With QuoteRegister To Reply
  9. 10-15-2010, 09:38 AM #9
    Domski
    Domski is offline
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Thanks Romperstomper

    Just goes to show I was pushing the boundaries even when I was 12
    Reply With QuoteRegister To Reply
  10. 10-15-2010, 01:57 PM #10
    Paul
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Thanks Romperstomper

    Is it this book you're raving about?

    http://www.amazon.com/Professional-E.../dp/0321508793

    Written by John Green, Rob Bovey, Dennis Walentin and Stephen Bullen.
    - Paul

    Click here to read the Forum Rules

    Reply With QuoteRegister To Reply
  11. 10-15-2010, 02:39 PM #11
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,303

    Re: Thanks Romperstomper

    Yep, that's the one.
    Reply With QuoteRegister To Reply
  12. 10-15-2010, 02:40 PM #12
    Paul
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Thanks Romperstomper

    Cool, I may just pick one up after reading the reviews online. Do you get a commission?
    Reply With QuoteRegister To Reply
  13. 10-15-2010, 05:38 PM #13
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,303

    Re: Thanks Romperstomper

    Sadly not.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1