Copy Auto-filtered data to new sheets
Thanks guys, I got it!!
"p45cal" wrote:
Was this line:
' ** Bomb Taking place on Next line **
ExistingFilterRng.Columns(FilterColumnWithState) _
.AutoFilter Field:=1, Criteria1:=MyCell.Value _
.SpecialCells(xlCellTypeVisible).Copy
.Paste Destination:=Range("A1")
a tad long (with a line continuation line too many?) and maybe should be
something like:
ExistingFilterRng.Columns(FilterColumnWithState).A utoFilter Field:=1,
Criteria1:=MyCell.Value
ExistingFilterRng.SpecialCells(xlCellTypeVisible). Copy
.Paste Destination:=Range("A1")
depending on what you're trying to achieve.
--
p45cal
"JMay" wrote:
Am having trouble with following macros on line 51 (and likely beyond..). Can
someone assist? Getting R/T 424 Obj required error
Thank in advance,,
[snip]
|