You would replace "sheet1" with the name of a sheet. I don't know where it
is used in the specific code you have selected to work with, so I can't say
whether it is the name of the sheet containing the original data or the name
of the sheet where you are placing a subset of the data matching a particular
key value.

--
Regards,
Tom Ogilvy


"JokerFrowns" wrote:

In Ron's example I am trying to work away at a solution, but I keep
getting stuck on this line, what do I need to "change"

Set ws1 = Sheets("Sheet1") '<<< Change