Re: $$Excel-Macros$$ How to copy a series of ranges from one worksheet to another

2014-03-07 Thread Rob Flott
DP, Sorry I didn't respond soonerthank you for you direction...much appreciated Rob On Thu, Feb 20, 2014 at 6:11 PM, De Premor wrote: > Hi Rob, > > Try this 2 code, first sub code just need a few line code, but it slower > than next sub code, i suggest second sub code if you have large d

Re: $$Excel-Macros$$ How to copy a series of ranges from one worksheet to another

2014-02-20 Thread De Premor
Hi Rob, Try this 2 code, first sub code just need a few line code, but it slower than next sub code, i suggest second sub code if you have large data list to process Sub Simple() Dim Rng As Range For Each Rng In Sheet1.UsedRange.Offset(1) If Not Trim(Rng) = "" Then