I have to take regular screenshots of part of a Excel worksheet to post
to a website, and I'm getting sick of it!! Does anyone know a way to
automate taking a screenshot of a set range in a  worksheet, and saving
it as a local file (e.g. a GIF file), using VBA?

I've done something similar in the past to save Excel charts to a
graphics file, but am struggling when doing the same with worksheet
entries -- any thoughts?

JW