Also be aware that a Range cannot exceed 255 characters - or maybe it is 256 - so if you are getting data from all over the sheet be careful - this has caused me many headaches. Since we are on the topic of 255(256) - be aware that you can only have 255 seriescollections in a chart. This must be a left over from the days of 8 bit computers.
Bookmarks